insert 'System user' using SQL Querry
536132Sep 27 2006 — edited Sep 27 2006hi all,
does we have sysuser as sysdate.
i am able to run the query:
create table date1 (data date);
insert into date1 values(sysdate);
in the same way i want to insert system user
create table user1(data varcahr2(30));
insert into user1 values(sysuser);
this insert statement is giving "column not allowed here" error. please let me know how to insert the system user into the table.
if i use 'shoe user' in sqlplus it showing the user.