OraOLEDB.Oracle seems not supporting subselct, is there a way to walk around it?
select id,(select 1 from dual) as abc from table;
this give "select1fromdual: invalid identifier" error when I use OraOLEDB.Oracle provider, but it works using MSDAORA.1 provider, however there's several other reasons i have to use OraOLEDB.Oracle, anyway to solve this?
P.S. I don't like the sub-select query, but there's too much job to do to change all queries with sub-select in the application