Re: Trying WHERE CONTAINS command

Why don't you try this?:

select * from All_tab_COLUMNS where TABLE_NAME like '%$TSP%'

Regards Rob

Peter DeSimone wrote in message <6vtkvf$ge9$1_at_news-2.news.gte.net>...
>I try this command in Oracle SQL Worksheet:
>
>select * from All_tab_COLUMNS where CONTAINS(TABLE_NAME, '$TSP')>0;
>
>
>I get this error:
>
>ORA-00604: error occurred at recursive SQL level 1
>ORA-06550: line 1, column 7:
>PLS-00201: identifier 'CTXSYS.DR_REWRITE' must be declared
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
>
>
>
>
Received on Mon Oct 12 1998 - 14:47:17 CDT