create or replace procedure create_table as
begin
execute immediate
'create table emp2(
id number,
name varchar2(10),
salary number)'; --动态SQL为DDL语句
insert into emp2
values (100,'jacky',5600);
insert into emp2
values (101,'rose',3000);
insert into emp2
values (102,'john',4500);
end create_table;
/
不知道那里出现问题了？
------解决方案--------------------
create or replace procedure create_table as
begin
execute immediate
'create table emp2(
id number,
name varchar2(10),
salary number)'; --动态SQL为DDL语句
execute immediate 'insert into emp2
values (100,''jacky'',5600)';
execute immediate 'insert into emp2
values (101,''rose'',3000)';
execute immediate 'insert into emp2
values (102,''john'',4500)';
end create_table;