SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get column name and table name given the column value

User_9RSSVSep 28 2012 — edited Sep 28 2012

Hi
I have a requirement as to find all the tables and columns containing keyword "SELECT" in my database.
I followed forum
9285068

But when i run the below query on 11.0.2g Oracle Database

select table_name,
column_name,
:search_string search_string,
result
from (select column_name,
table_name,
'ora:view("' || table_name || '")/ROW/' || column_name || '[ora:contains(text(),"%' || :search_string || '%") > 0]' str
from cols
where table_name in ('TEST')),
xmltable (str columns result varchar2(10) path '.')
/

I get
ORA-29913: error in executing contains callout
ORA-20000: Oracle Text error:
29913. 00000 - "error in executing %s callout"
*Cause: The execution of the specified callout caused an error.
*Action: Examine the error messages take appropriate action.

Please help

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 26 2012

Added on Sep 28 2012

#database, #error, #pl-sql, #search, #text

5 comments

2,761 views