OraFAQ Forum: Server Administration » default table values

Home » RDBMS Server » Server Administration » default table values

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

default table values [message #172682]

Wed, 17 May 2006 11:10

Zakkhalid
Messages: 47
Registered: April 2005

Member

Hi All,

I have a table which has default values assigned to some columns. How do I find out what these default values are? I''ve tried user_tab_columns and user_tables...

thanking you all inadvance...

Report message to a moderator

Re: default table values [message #172684 is a reply to message #172682]

Wed, 17 May 2006 11:36

ebrian
Messages: 2794
Registered: April 2006

Senior Member

DATA_DEFAULT column in USER_TAB_COLUMNS

Report message to a moderator

Re: default table values [message #172821 is a reply to message #172684]

Thu, 18 May 2006 03:25

Zakkhalid
Messages: 47
Registered: April 2005

Member

i did try that... but of course it would have been better if I had run the query against the right table... apologies Embarassed

Report message to a moderator

Previous Topic:	SYSTEM tablespace
Next Topic:	error in login in oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:54:45 CDT 2024