Re: get table colum
From: sakai tadashi <toby_at_muh.biglobe.ne.jp>
Date: Sat, 21 Jul 2001 21:53:18 GMT
Message-ID: <9gdglm$939$1_at_bgsv5905.tk.mesh.ad.jp>
Date: Sat, 21 Jul 2001 21:53:18 GMT
Message-ID: <9gdglm$939$1_at_bgsv5905.tk.mesh.ad.jp>
Thank you Mr.Dorlon.
"John Dorlon" <john_at_ezsql.net> wrote in message
news: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 Sat Jul 21 2001 - 23:53:18 CEST