Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: table's column names
Filipe David Borba Manana wrote:
> Greetings!
>
> How can I discover the name of all the columns for each table defined by
> a user?
> Is there any system table which I can query for that purpose?
>
> many thanks
SELECT
OWNER,
TABLE_NAME,
COLUMN_NAME,
DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE,
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Mon Nov 27 2006 - 09:02:28 CST