8 Replies Latest reply on Jan 30, 2017 7:41 PM by Vadim Tropashko-Oracle

    Searching for column does not bring it when it belongs to a View




      So I have a column named: edi_ref_id

      If I do a search using Find Database Objects. Everything is checked: All Objects Types, Al Identifiers Types, etc.

      Type the name, choose the connection and hit go.

      It brings results from tables and code. But not from the sql of the Views.

      I mean:

           create or replace view myview as ( select edi_ref_id from arsedi);


      Will show edi_ref_id in the results.


           create or replace view myview2 as ( select nvl(edi_ref_id,'810') ref_id from arsedi);


      Will not show in the results.


      I think it should show it.