在oracle中如何用一条sql语句把一个表中多条记录写到另外一个表中:
insert into Table2(vehicleno,username) select vehicleno ,'coco' from table1 where vehicleno like '%XX%' and vehicleProNo='XX'
在oracle中如何用一条sql语句把一个表中多条记录写到另外一个表中:
insert into Table2(vehicleno,username) select vehicleno ,'coco' from table1 where vehicleno like '%XX%' and vehicleProNo='XX'