Development Tools: How to use Expert mode of View Object and no generating inline view SQL

• mrosero_ssasis / 400 / Thurs, 18 Jun 2009 08:35:00 GMT / Comments (0)
• 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
• Keywords:

  expert, mode, view, object, generating, inline, sql, tools

• http://programming.itags.org/development-tools/60032/«« Last Thread - Next Thread »»