Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00933: SQL command not properly ended ?
ORA-00933: SQL command not properly ended ? [message #198621] Wed, 18 October 2006 00:48 Go to next message
highvoltage
Messages: 12
Registered: October 2006
Location: Singapore
Junior Member
Insert into Customer (custId,Last,First,Mi,Address,city)
values
(1,'Harris','Paula','E','1156 Water Street','Osseo'),
(2,'Gracia','Maria','H','2211 Pine Drive','Radisson');

Anyone whats wrong with this commmand?
Re: ORA-00933: SQL command not properly ended ? [message #198624 is a reply to message #198621] Wed, 18 October 2006 00:54 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,


should be something like this.
insert all into test
values('scott',2000,'salesman')
into test
values('adams',3000,'analyst')
select * from dual



regards,
Previous Topic: Create field of CLOB datatype with a size of 30000
Next Topic: ora-12560: TNS: protocol adapter error
Goto Forum:
  


Current Time: Sat Dec 03 22:30:44 CST 2016

Total time taken to generate the page: 0.09351 seconds