I have a column that I want defaulted to the current user doing the Insert into the table? I have SYSTIMESTAMP as my default for the CREATE_DATE column but now I want the CREATE_BY column defaulted to SYSUSER(I think that is for SQL Server)
Check any Oracle SQL reference for the syntax, but you're simply passing the parameter when you define or modify the column, such as column name default sysuser.
ASKER CERTIFIED SOLUTION
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Looks like User will work for me. .
Thanks Slight. Taking this a bit further so Im posting another question...