--在过程中不支持这种语法14:08:11 jlanzpa817>insert into ZYQ_TEST select CLUSTERID from tab order by tname;已创建21行。已用时间: 00: 00: 00.20
14:08:25 jlanzpa817>create or replace procedure sp_createcjtask
14:08:29 2 as
14:08:29 3 begin
14:08:29 4 insert into ZYQ_TEST select CLUSTERID from tab order by tname;
14:08:29 5 commit;
14:08:29 6 end;
14:08:30 7 /警告: 创建的过程带有编译错误。已用时间: 00: 00: 00.30
14:08:31 jlanzpa817>
14:08:25 jlanzpa817>create or replace procedure sp_createcjtask
14:08:29 2 as
14:08:29 3 begin
14:08:29 4 insert into ZYQ_TEST select CLUSTERID from tab order by tname;
14:08:29 5 commit;
14:08:29 6 end;
14:08:30 7 /警告: 创建的过程带有编译错误。已用时间: 00: 00: 00.30
14:08:31 jlanzpa817>
14:46:12 jlanzpa817>create or replace procedure sp_createcjtask
14:46:18 2 as
14:46:18 3 begin
14:46:18 4 insert into ZYQ_TEST select * from ttt;
14:46:18 5 commit;
14:46:18 6 end;
14:46:19 7 /过程已创建。已用时间: 00: 00: 01.72
14:46:21 jlanzpa817>exec sp_createcjtaskPL/SQL 过程已成功完成。已用时间: 00: 00: 00.20