Re: get table colum
From: John Dorlon <john_at_ezsql.net>
Date: 15 Jun 2001 07:17:09 -0700
Message-ID: <a8097a33.0106150617.2b3f62bc_at_posting.google.com>
Date: 15 Jun 2001 07:17:09 -0700
Message-ID: <a8097a33.0106150617.2b3f62bc_at_posting.google.com>
"sakai tadashi" <toby_at_muh.biglobe.ne.jp> wrote in message news:<9gcpfo$n3n$1_at_bgsv5905.tk.mesh.ad.jp>...
> Hello!
> I want to get table colums by sql without DESC command.
>
> Ex.
>
> Select ????? from aaatable;
>
> a vchar(8);
> b number(10)
>
> primary key{
> XXXXX
> }
>
> please tell me.
select * from dba_tab_columns
where owner = 'TABLE_OWNER'
and table_name = 'TABLE_NAME'
for the primary key, you need to look at DBA_CONSTRAINTS and DBA_INDEXES and DBA_IND_COLUMNS Received on Fri Jun 15 2001 - 16:17:09 CEST