created by and creation date default values on form
640410Jan 18 2010 — edited Jan 19 2010Hi Friends,
I am a form newbie. I am creating a simple form.
I have non-display column/fields:
a.) CREATED_BY - how do I put the default value of the user login ID upon inserting record?
b.) CREATION_DATE - how do I put the SYSDATE upon inserting the record?
c.) UPDATED_BY - how do I put the default value of the user login ID when updating the record?
d.) UPDATE_DATE - how do I put the SYSDATE when updating the record?
Thanks a lot in advance