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 Statement with Where Clause

494206Apr 9 2007 — edited Apr 9 2007
I m using this but giving error "Encounter the Symbol "Where" when expecting one of the following.

Code is :-

insert into dum (cost_no, c_size, cmt1, cmt2, cmt3)
values (:sizecost.cost_no, :sizecost.c_size, :bottomcost.cmt1, :bottomcost.cmt2, :bottomcost.cmt3)
where :sizecost.cost_no := :costmain.cost_no;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2007
Added on Apr 9 2007
5 comments
562 views