使用SQL语句产生插入语句

郑全

select 'insert into employees(employee_id,last_name,hire_date,salary,department_id) values(' || employee_id || ',''' || last_name || ''',''' || hire_date || ''',' ||
  2         salary || ',' || department_id || ');'
  3     from hr.employees;

'INSERTINTOEMPLOYEES(EMPLOYEE_ID,LAST_NAME,HIRE_DATE,SALARY,DEPARTMENT_ID)VALUES('||EMPLOYEE_ID||','''||LAST_NAME||''','''||HIRE_DATE||''','||SALARY||','||DEPARTMENT_ID||');'
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(100,'King','17-JUN-11',24000,90);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(101,'Kochhar','21-SEP-09',17000,90);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(102,'De Haan','13-JAN-09',17000,90);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(103,'Hunold','03-JAN-14',9000,60);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(104,'Ernst','21-MAY-15',6000,60);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(107,'Lorentz','07-FEB-15',4200,60);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(124,'Mourgos','16-NOV-15',5800,50);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(141,'Rajs','17-OCT-11',3500,50);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(142,'Davies','29-JAN-13',3100,50);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(143,'Matos','15-MAR-14',2600,50);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(144,'Vargas','09-JUL-14',2500,50);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(149,'Zlotkey','29-JAN-16',10500,80);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(174,'Abel','11-MAY-12',11000,80);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(176,'Taylor','24-MAR-14',8600,80);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(178,'Grant','24-MAY-15',7000,);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(200,'Whalen','17-SEP-11',4400,10);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(201,'Hartstein','17-FEB-12',13000,20);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(202,'Fay','17-AUG-13',6000,20);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(205,'Higgins','07-JUN-10',12008,110);
insert into employees(employee_id,last_name,hire_date,salary,department_id) values(206,'Gietz','07-JUN-10',8300,110);