I was searching for some code using Toad and was trying to find some code that handles the column PDF_FILE. But to my surprise I could not locate the field LIMS.U_INVOICE_USER.U_PDF_FILE using the Object Search.
Time to spool the executed code and the following section should handle the table column names (replaced the :olike with the search string)?
SELECT allo.owner
,DECODE(allo.object_type
,‘VIEW’, ‘VIEW COLUMN’
,‘TABLE’, ‘TABLE COLUMN’
,‘MATERIALIZED VIEW’, ‘MATERIALIZED VIEW COLUMN’
,‘CLUSTER’, ‘CLUSTER COLUMN’
,‘UNDEFINED’, ‘UNDEFINED COLUMN’
,’ ')
object_type
,atc.table_name result_type
,atc.column_name object_name
FROM sys.dba_tab_columns atc, sys.dba_objects allo
WHERE UPPER(atc.column_name) LIKE ‘%PDF_FILE%’ ESCAPE ‘’
AND allo.owner = atc.owner
AND allo.object_name = atc.table_name
AND atc.owner IN (‘LIMS’)
AND allo.object_type IN (‘CLUSTER’, ‘CONSTRAINT’)
when I comment out the last line this section delivers a correct result. It looks like that the checkboxes for the different column types are not added to the query correctly, and yes they are all checked when I run the object search.
Groetjes,
Wim