Re: Default values

Haresh Assumal wrote:

> How do I find out what default values are set for a table? I can use
> the
> DESCRIBE command to find the columns in the table but how do I fund
> the
> default (if any)????

Haresh,

try:
select
  table_name,
  column_name,
  data_default
from
  user_tab_columns
where
  data_default is not null
;

Stephan Schaefer
stesch_at_camline.com Received on Tue Mar 17 1998 - 00:00:00 CST