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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Column Added to Table

Status
Not open for further replies.
ninfan

ninfan

Programmer
Feb 16, 2001
49
US
I have a need to try to identify columns that have been incrementally added to a table since its initial creation. I have searched ALL_TAB_COLUMN and related tables but I don't see a timestamp attribute. Any thoughts on how I might accomplish this? Thank you!
 
Sort by date Sort by votes
As far as I know Oracles stores only the creation date and the last modification date. You may query them from all_objects.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
682
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
650
SkipVought
S
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
286
Livia8
Livia8
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
622
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top