Looking for a Column Name in 8.05

From: Tim Marshall <tmarshal_at_morgan.ucs.mun.ca>
Date: Mon, 27 Jan 2003 16:54:01 -0330
Message-ID: <3E359561.33F6C07E_at_morgan.ucs.mun.ca>

[Quoted] [Quoted] Hi there, I'm trying to find all column names that contain a certain [Quoted] 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

Received on Mon Jan 27 2003 - 21:24:01 CET