Skip to Main Content

SQL Developer

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 Statement Updated by

SQLE KumarMay 26 2022 — edited May 27 2022

Hi All,
I am trying to insert records into a table as below
INSERT INTO table2 (Emp_ID, Emp_Name, Sal, update_by)
SELECT Emp_ID, Emp_Name, Sal,? FROM table1.
For Updated_By I need some function or wild character that automatically insert Users who is executing the Insert statement.

Kindly advise.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 23 2022
Added on May 26 2022
3 comments
184 views