Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert 'System user' using SQL Querry

536132Sep 27 2006 — edited Sep 27 2006
hi 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 25 2006
Added on Sep 27 2006
3 comments
858 views