oracle - error getting while inserting multiple rows in sql -
my table
create table emp( emp_no number, emp_name varchar2(10 byte), address varchar2(15 byte), ph_no number(10,0), dpt_no number )
inserting query:
insert emp ( emp_no, emp_name, address, ph_no, dpt_no) values (100,'mohan','hyd',7569936347,101), (101,'ram','ctr',9553438342,102);
in manner write insert query multiple records inserting purpose...but i'm getting error "sql command not perperly ended.i don't know how rwsolve 1 one..any can me
assuming using sql server prior 2008. cannot use syntax separate rows. write different insert commands or use select statement using union force them 1 insert command.
edit: since using oracle see if this helpful.
Comments
Post a Comment