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 SkipVought 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
0
0
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

Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
307
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
143
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
139
SkipVought
S
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
139
Livia8
Livia8
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
172
carp
carp

Part and Inventory Search

Sponsor

Back
Top