PL⼀SQL中提示未找到要求的from关键字

2025-04-04 18:31:01
推荐回答(1个)
回答1:

oracle里要这么用才对,你这个类似于sqlserver的写法

insert into abcd
select '10','Administration','1700','1' from dual
union allselect '20','Marketing','1800','2'  from dual
union allselect '50','Shipping','1500','5'  from dual
union allselect '60','IT','1400','3' from dual
union allselect '80','Sales','2500','3' from dual
union allselect '90','Executive','1700','3' from dual
union allselect '110','Accounting','1700','2' from dual
union allselect '190','Contracting','1700','0' from dual;