OraFAQ Forum: SQL & PL/SQL » how to know the time of creation of column

Home » SQL & PL/SQL » SQL & PL/SQL » how to know the time of creation of column

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

how to know the time of creation of column [message #241793]

Wed, 30 May 2007 11:33

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

how can I get the details about when a column in a table has been created ?

any data dictionary table which provides this info ?

Report message to a moderator

Re: how to know the time of creation of column [message #241796 is a reply to message #241793]

Wed, 30 May 2007 11:38

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Sorry, Oracle doesn't store column creation time at all.

PS: Looks like SYS.COL$(SPARE6) may be used for this in future.

Report message to a moderator

Re: how to know the time of creation of column [message #241797 is a reply to message #241793]

Wed, 30 May 2007 11:38

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No, you only have the last DDL time on the table (and adding a column is a DDL) but no time for a specific column.

Regards
Michel

Report message to a moderator

Re: how to know the time of creation of column [message #241799 is a reply to message #241793]

Wed, 30 May 2007 11:42

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

so from which table can i get the DDL statements details ?

Report message to a moderator

Re: how to know the time of creation of column [message #241803 is a reply to message #241793]

Wed, 30 May 2007 11:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>how can I get the details about when a column in a table has been created ?
LOGMINER could provide the details.

Report message to a moderator

Re: how to know the time of creation of column [message #241813 is a reply to message #241793]

Wed, 30 May 2007 11:56

rolex.mp
Messages: 161
Registered: February 2007

Senior Member

can i know which procedure specifies the the data inside the package ?
also let me know whether any parameter has to be set in init.ora to get these details ?

Report message to a moderator

Re: how to know the time of creation of column [message #241815 is a reply to message #241799]

Wed, 30 May 2007 11:58

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You mean the DDL of table creation?
Use dbms_metadata.get_ddl function.

Regards
Michel

Report message to a moderator

Re: how to know the time of creation of column [message #241817 is a reply to message #241813]

Wed, 30 May 2007 11:59

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

can i know which procedure specifies the the data inside the package ?

What does this mean? Can you explain?
Do you want the source of a package?

Regards
Michel

Report message to a moderator

Previous Topic:	Refrential Integrity Query
Next Topic:	query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 09 21:02:33 CST 2024