How to find the Date and Time of Modification of Column in aTable?

Advertisement

Hi all,
Do  you know how to find the Date and Time of Addition of Column to a Particular Table?.
I know however, How to find the modification time of the Table. Using the below Query :
Select Object_Name, to_Char(Last_DDL_TIME, 'DD-Mon-YYYY HH24:MI:SS') Last_DDL from User_Objects where Object_Type = 'TABLE';
Object_Name
Last_DDL
Employee
20-Aug-2013 09:23:03
I wanted to know the Creation or Modification Date and Timestamp of all columns of Employee Table?. Is it possible at all. If possible, How to get it?.
Regards,
Bhaskar M

Advertisement

I agree with you on that. Since its a development enviornment I can remove the column but that not my point here.
My whole purpose it to know whether we get the Column's Creation or Modification DateTime.

October 11, 2015

How to find the Date and Time of Modification of Column in aTable?

Hi all, Do  you know how to find the Date and Time of Addition of Column to a Particular Table?. I know however, How to find the modification time of the Table. Using the below Query : Select Object_Name, to_Char(Last_DDL_TIME, 'DD-Mon-YYYY HH24:MI:S

How to check the date and time when a material is blocked

Hello,    Please tell me how can i check the date and time when a material is blocked or unblocked. Regards, PriyankaHi Pryianka, Are you speaking about blocked status of material master ('X-plant matl status' > MM03 > Basioc view 1; 'Plant-sp. matl

How to get the date and time of the last KM scheduled run

Hi Experts, I had a scenario where i need to send the last date and last time when the KM schduler runned.? Issue: I have created a Km sheduler, in that i have written the jave code to retrieve the details from a function module and getting the outpu

Set the date and time

how to set the date and time in apple tv?Welcome to the Apple Community. Assuming this is not the first time you have used your Apple TV You might try restarting the Apple TV by removing ALL the cables for 30 seconds. Also try restarting the router.

Ajust the date and time on a LCD 46TL938

I intend to learn how to ajust the date and time on a LCD 46TL938 (it shows the time&date when I push I+)That doesn't appear to be a US model, and this is the forums for Toshiba USA. You may want to contact Toshiba in your region. - PeterRead other 2

In Numbers, how do I lock in the date and time data when an IF/THEN formula is used with the "NOW" function?

In Numbers, how do I lock in the date and time data when an IF/THEN formula is used with the "NOW" function? =IF(I127,NOW()," ") I127 equals a check box. The formula retuns a value of the current date and time when a check is placed in

How do you edit out the date and time stamp from a photo

How do you edit out the date and time stamp from a photoYou can blur it out with retouch The built-in "Retouch" brush in "Edit" mode should suffice, if the background is mostly uniform, and if you set the size of the brush to slightly

Every time I create a new row, I want a certain cell to display the date and time the row was created.  How do I do that?

=NOW() updates the date and time continuously, I don't want to do that.  I just want the date and time in that cell to stay the same after that row is created.  Seems like this would be easy, but I can't figure it out.My preferred scheme is a variant

Reseting the date and time on photosmart 5510

Having replaced the internal battery,the date and time on scanned items to memory card is giving 1st january 2001.how can i reset this.Hey @dube55, I am aware that your Photosmart model does not have a fax. Because I do not have a Photosmart 5510 her

How to get system date and time?

Can someone show me a code on how to get system date and time. Thanks!there is one really easy way to get system time, the api gives a great example of code on this. use gregorian calendar, which you'll find in the api under GregorianCalendar. You on

Printing the date and time on a photo

The date and time that the photo was taken showes up but how do I get it to print on my photos?You can print the date just below the photo on a printout by using 'Contact Sheet' option while printing the photo through Photoshop Album Starter Edition.

How do i format date and time in SSRS 2008

Okay, so i am working with SSRS 2008. I am formatting the date and time. Right now the current out put is 1/13/2014 8:02:11 AM. I want the output to be 1/13/14 8:02 AM. What is the expression for this?  Thanks in advanceThere are 2 functions that can

Getting the date and time from NIST server

I need to be able to get the date and time in an app and cannot trust the device's clock since the user could change it. Has anyone got an example of how to access an Internet time server such as the NIST servers from AIR for iOS?What is the best way

How to find the data loaded from r/3 to bw

hi how to find the data loaded from r/3 to bw is correct . i am not able to find which feild in the query is connected to which feild in the r/3 . where i am geting the data from r/3 . is there any process to find which feild  and table the data is c

Get the date and time from iframe.

Hi, Am using jdeveloper 11.1.1.6.0., I have used the following iframe source which gets the date and time. <af:form> <iframe src="http://free.timeanddate.com/clock/i3xb4nm0/n1722/tt0/tw0/ts1" frameborder="0" width="244&qu

How to include install date and time in registry keys

Hi All, Hopefully someone can help me. I am creating an installer which includes some properties in the build specs. I also wannt to include some registry keys to be added upon installation: 1. I include the install directory of the application by pr

Where i will give the date and time of the session background process

Hi. I created a program on XD01 by using Session Method. It is executed properly and process in forground also fine. What my problem is i want execute process of session in Back ground on that time i want give the Date and Time. I do not know where i

How to find the font and replace another font using javascript in illustrator?

Dear All, how to find the font and replace another font using javascript [batch process] in illustrator? i have 700 image file, it very deficult replace one by one. regards, .Suresh.SAsk the creator of the file for a unprotected version.Read other 2

Can Iphoto display the date and time of a pic on the pic?

I know I can get info and see a pics info, but can Iphoto display the date and time of a pic on the pic itself?Use the Photos->Batch Change menu option to set the Title to Date and Time. That will give you what you want under each thumbnail. TIP: For

Hello! i am using ipad n i am not able to connect to itunes store.Whenever i open itunes it syas "cannot connect to itunes store".i tried resetting the network settings n also tried changing the dat and time settings as mentioned but it still doesnt work!

hello! i am using ipad n i am not able to connect to itunes store.Whenever i open itunes it syas "cannot connect to itunes store".i tried resetting the network settings n also tried changing the dat and time settings as mentioned but it still do