Oracle sql update date and time

Else you get an error, so it's safest to first do a: left join sys. Justin Cave Justin Cave k 22 22 gold badges silver badges bronze badges. Whoa, that's really cool.

I've missed that pseudocolumn. What is a row is deleted? How can I find out? Ask your DBA about auditing. Sadly, "Asking the DBA" tend's to be rather complicated. They are really paranoid about changing stuff. I do understand them. If anything is wrong with this db, things tend to get ugly. This would require you to gather statistics on the table first, since it only shows changes after the last gather statistics.

Sounds interesting. Can you include an example of creating a hash for a table? Mark Brady Mark Brady. Hopefully it will be in the future. Would you consider that "Special Admin Stuff"? It would be better to describe what you're actually doing so you get clearer answers. Tony Andrews Tony Andrews k 20 20 gold badges silver badges bronze badges. That's the problem: I don't just write the data but I need to process it in a complicated way. This takes several hours and this what I'm trying to avoid.

TMtech TMtech 7 7 silver badges 13 13 bronze badges. Renjith 5, 9 9 gold badges 29 29 silver badges 42 42 bronze badges. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Linked 1. Related Hot Network Questions. Question feed. Does anyone know how I would change the date to the one desired? Improve this question. BryanH 5, 3 3 gold badges 35 35 silver badges 47 47 bronze badges. Stack Over Stack Over 1 1 gold badge 3 3 silver badges 4 4 bronze badges. Define Not Working Error messages?

Unexpected results? I want to try that but I am afraid I won't be able to change it back to the date with the slashes Add a comment. Active Oldest Votes. Improve this answer. Alex Poole Alex Poole k 9 9 gold badges silver badges bronze badges.

Nick Nick 29 4 4 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.