Re: SQL for retrieving default value of a table
From: Girts Graudins <ggraudins_at_my-deja.com>
Date: 2000/02/16
Message-ID: <88enu6$itj$1_at_nnrp1.deja.com>#1/1
Date: 2000/02/16
Message-ID: <88enu6$itj$1_at_nnrp1.deja.com>#1/1
> 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/