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?
[Quoted] 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 Wed Feb 16 2000 - 00:00:00 CET