Re: Looking for a Column Name in 8.05
From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Mon, 27 Jan 2003 21:28:21 GMT
Message-ID: <VvhZ9.504$7H4.60602570_at_newssvr15.news.prodigy.com>
Date: Mon, 27 Jan 2003 21:28:21 GMT
Message-ID: <VvhZ9.504$7H4.60602570_at_newssvr15.news.prodigy.com>
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.
Try uppercase: ...like '%PART%'
Received on Mon Jan 27 2003 - 22:28:21 CET