Re: Looking for a Column Name in 8.05

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 28 Jan 2003 08:53:17 +0100
Message-ID: <1043740304.566992_at_news.thyssen.com>


"DA Morgan" wrote...
> SELECT table_name, column_name
> FROM all_tab_columns
> WHERE column_name LIKE '%PART%';
>
> Daniel Morgan
>

Hi Daniel,

please allow me a little addition as I think that the OP is not very familiar with ORACLE stuff. Your solution will give the column names that the user has access to. If you really need *all* columns, then you have to have access to dba_tab_columns.

Sorry for pointing out the obvious.

Greetings,
Guido Received on Tue Jan 28 2003 - 08:53:17 CET

Original text of this message