| parveez |
Posted: Aug 18, 2007 01:27:17 PM |
Total Post: 20
Joined: Aug, 2007
|
| I want to add a new column in my table with date data type which will be default to sysdate.But there are datas which have been previously entered by data entry operators and are still doing it. I know that when i make the table changes the sysdate of the computer gets inserted into all the rows.But i want the sysdate in my new insertions so that i can find out when the data entry has been done.I also want the date of the previously entered data to get inserted in the newly added column.Please give me step wise procedure.U people can also give me an idea how to find the date of insertions made by that way i will be able to solve. |
|
|
 Ramesh Joyisa |
| Posted: Aug 22, 2007 01:54:08 AM |  |
|
Total Post: 226
Joined: Aug, 2007
|
you want to get the date for already inserted rows also? i think it is not possible. I suggest you to add a new column and update the existing data with some date and make the sysdate as default for the column so that the current date will be updated for all new entries
|
|
|
|
|
| parveez |
| Posted: Aug 22, 2007 12:44:28 PM | |
|
Total Post: 20
Joined: Aug, 2007
|
Yes we dont have the facility in Oracle 9i or 10g to check the date of inserts.That is a great disadvantage.I think the feature will be there in coming versions.Audit trial and log minar does not help.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
