Re: SQL for retrieving default value of a table
From: Harmony Wong <harmony_wong_at_hongkong.com>
Date: 2000/02/17
Message-ID: <88gcoe$491$1_at_news.hk.linkage.net>#1/1
Date: 2000/02/17
Message-ID: <88gcoe$491$1_at_news.hk.linkage.net>#1/1
thx so much :>
Harmony
Girts Graudins <ggraudins_at_my-deja.com> wrote in message
news:88enu6$itj$1_at_nnrp1.deja.com...
>
> > Does anyone know the sql of this?
>
> If, by any chance, you're looking for default values for data in the
> table:
>
> SQL> SELECT column_name, data_default FROM dba_tab_columns WHERE
> table_name = 'YOUR_TABLE';
>
>
> Girts
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Feb 17 2000 - 00:00:00 CET