0

Trying to insert multiple records into table with single insert statement but its throwing error . Is it correct method to do

SQL Error: ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause:
*Action:

insert into customers values (100356,'ramo',89638527410,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','Mexico')
 (100356,'ramo',89638527417,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','Finland')
 (100356,'ramo',89638527418,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','Ireland')
 (100356,'ramo',89638527419,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','Newjersey')
 (100356,'ramo',89638527414,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','rome')
 (100356,'ramo',89638527415,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','canada')
 (100356,'ramo',89638527416,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','Namabia')
 (100356,'ramo',89638527411,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','SouthAfrica')
 (100356,'ramo',89638527413,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','England')
 (100356,'ramo',89638527415,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','Ontario')
 (100356,'ramo',89638527416,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','London')
 (100356,'ramo',89638527414,to_date('13-04-2023','dd-mm-yyyy'),'[email protected]','Mexica');

Using ORACLE Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production

Nick.Mc
  • 18,304
  • 6
  • 61
  • 91
sandeepkalasikam kumar
  • 1
  • @tripleee I've worked with Oracle for 25 years and never knew about the INSERT ALL syntax. Thanks for teaching an old dog a new trick! – Sam M Apr 11 '23 at 04:32
  • Thanks, but I'm only the messenger here; somebody posted the link as an answer (which was subsequently deleted as not really an answer) and I simply copied that into a close vote. If it solved your problem, please acknowledge the duplicate. Thanks again. – tripleee Apr 11 '23 at 04:41

0 Answers0