Re: Where can I see the 'default' value on a column?

It's in the data_default column in dba_tab_columns.

Guang Mei wrote:

> Hi,
>
> A quick question. If I do
>
> create table t1 (col1 varchar2(20) default '12345' );
>
> How can I query the database to see that there is a default value '12345' on
> t1.col1? I looked at "user_constraints" and could not find it.
>
> Thanks.
>
> Guang
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Tue Aug 22 2000 - 14:55:59 CDT