There is a way to tell Jdeveloper not generate inline view for queries that use Expert mode?
I have a problem with inline views on Database that use 10.1.0.4.0 and a select that use decode and parameters from a table access by dblinks
My selecct look like this
===========================================================
SELECT * FROM (SELECT DISTINCT remotetableusingdblink.somecolumn DECODE (:0, 'SOMESTRING', somecolumn, NULL ) oficial_id, DECODE (:1, 'SO MESTRING2', NULL, somecolumn2 ) id_cluster, localtableonmyschema.cod_banca FROM remotetableusingdblink gruposcomerciales) QRSLT WHERE (cod_banca = :2 AND id_cluster = :3 AND oficial_id = :4)
===========================================================
This select give me no rows using inline view
If i use the same select without inline view on my sqlplus work fine and give me rows, so i think maybe a bug of inline views and 10.1.0.4.0 or any other problem
SELECT DISTINCT remotetableusingdblink.somecolumn DECODE (:0, 'SOMESTRING', somecolumn, NULL ) oficial_id, DECODE (:1, 'SOMESTRING2', NULL, somecolumn2 ) id_cluster, localtableonmyschema.cod_banca FROM remotetableusingdblink gruposcomerciales WHERE (cod_banca = :2 AND id_cluster = :3 AND oficial_id = :4)
Any Help on this
Best Regards