Re: Looking for a Column Name in 8.05

Tim Marshall wrote:

> Hi there, I'm trying to find all column names that contain a certain
> text, say "part" in my Oracle tables.
>
> I've tried:
>
> select column_name from all_all_tables where column_name like '%part%'
>
> And this does not work. Any suggestions? Thanks in advance.
> --
> Tim - http://www.ucs.mun.ca/~tmarshal/
> ^o<
> /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
> /^^ "Want some?" - Ditto

[Quoted] SELECT table_name, column_name
FROM all_tab_columns
WHERE column_name LIKE '%PART%';

Daniel Morgan Received on Tue Jan 28 2003 - 00:33:53 CET