Toad World® Forums

Cannot find column in 12.1 and 12.5 beta

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

google.com/+WimdeLange

Yeah, that looks like a bug. I’ll fix it. thanks.