How can I check DEFAULT value of COLUMN in Table ?

[edwtsang]

Hi there,

How to check the DEFAULT VALUE in column of table
without using any Graphical Management or SQL/netvigator

Regards,
Edward.

[Newton]

Hi there Just check

User_Tab_Columns or DBa_Tab_Columns

It will give you default values that were given on creation of any table.

Column name is Data_Default.

Hpe it helps.

Thanks.