Skip to Main Content
Forums

Oracle Database Discussions

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 into Table1 as Select: error ORA-00926 - missing Values keyword

muttleychessApr 19 2007 — edited Apr 19 2007
Hi
I tried to insert data in Table1 with equal columns table2, but when I tried return error
ORA-00926 - missing Values keyword

I am doing as
   INSERT INTO TABLE1 AS
     SELECT * FROM TABLE2;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 17 2007
Added on Apr 19 2007
#general-database-discussions
11 comments
3,955 views