Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to determine the default values?

Status
Not open for further replies.
6656

6656

Programmer
Nov 5, 2002
104
US
Greetings,

Is there any system view can be used to extract the default values of a table?

Thanks in advance!
Mike
 
Sort by date Sort by votes
Yes - check the data_default column of the dba_tab_columns view.
 
Upvote 0 Downvote
Thanks a lot.
It can be acquired from all_tab_columns or user_tab_columns as well.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Locked
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
154
jj10438
J
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
1K
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
773
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
861
SkipVought
S
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
783
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top