insert current_user() by default
I have a table like
create table try ( firstname varchar(4), username varchar(4))
My question is that is there a way to insert the current_user() or user() value in the username field by default.
So for example if I am logged in to the database as 'abcduser' then
>insert into try values( 'kashif');
>select * from try
kashif abcduser
Is this possible , just how I can insert defualt timestamp by doing something like
ARRIVAL_TIME timestamp not null DEFAULT CURRENT_TIMESTAMP
is this is not possible, then what are the alternatives?
Subject
Written By
Posted
insert current_user() by default
February 13, 2013 01:14PM
February 13, 2013 03:00PM
February 13, 2013 08:07PM
February 13, 2013 09:38PM
February 14, 2013 06:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.