Home » SQL & PL/SQL » SQL & PL/SQL » where to find the default value
where to find the default value [message #6558] Thu, 24 April 2003 23:27 Go to next message
shawlin
Messages: 25
Registered: April 2003
Junior Member
Hello

where to find the default values
set for each table.Is there any
table to look for.
Kindly help me in this regard.

thanks and regards
shawlin

Report message to a moderator

Re: where to find the default value [message #6559 is a reply to message #6558] Thu, 24 April 2003 23:46 Go to previous message
Deepa
Messages: 269
Registered: November 2000
Senior Member
hi,

Querying the dba_tab_columns will give u the needed .

Eg:
select column_name,data_default from DBA_TAB_COLUMNS
where table_name=' '

Regards,
Deepa

Report message to a moderator

Previous Topic: How to access a cursor variable returned by a function
Next Topic: is it necessary
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 17:22:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.