Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LAST_UPDATE_DATE update on row change of just attribute?

Jason ORCLNov 16 2009 — edited Nov 16 2009
Does running a statement like this update the 'last updated date' in the row? or do i need to update that to sysdate?

UPDATE PO_HEADERS_ALL
set attribute1 = 'X'
where header_id = 1234

or is this necessary?

UPDATE PO_HEADERS_ALL
set attribute1 = 'X', last_updated_date = sysdate
where header_id = 1234
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 14 2009
Added on Nov 16 2009
1 comment
530 views