Link to home
Start Free TrialLog in
Avatar of 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
Avatar of Sean Stuber
Sean Stuber

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