Link to home
Start Free TrialLog in
Avatar of chalie001
chalie001

asked on

add user when record is inserted

hi in oracle 18c is there a way to set value default value like user or sysdate instead of writing trigger
alter table table_name
add created_by varchar(50) user;

alter table table_name
add created_date date sysdate;

Open in new window


when new records is insterted i what this value to be created
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial