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 Rhinorhino 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
Joined
Nov 5, 2002
Messages
104
Location
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 Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report
Replies
0
Views
633
jj10438
J
Livia8
  • Locked
  • Question Question
How to forcibly logout users
Replies
17
Views
2K
carp
carp
Chopstik
  • Locked
  • Question Question
How to identify a package based on a code snippet
Replies
1
Views
1K
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
1K
SkipVought
S
Livia8
  • Locked
  • Question Question
Alternative to "locate" command
Replies
0
Views
1K
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top