需要使用动态sql
v_SqlString := 'create table students(id number(5) primary key,first_name varchar2(20),last_name varchar2(20),major varchar2(30),current_credits number(3))'
EXECUTE IMMEDIATE v_SqlString;
v_SqlString := 'create table students(id number(5) primary key,first_name varchar2(20),last_name varchar2(20),major varchar2(30),current_credits number(3))'
EXECUTE IMMEDIATE v_SqlString;
str:='create table tbname (...)';
execute immediate str;str:='drop table tbname';
execute immediate str;
v_SqlString := 'create table students(id number(5) primary key,first_name varchar2(20),last_name varchar2(20),major varchar2(30),current_credits number(3))';
EXECUTE IMMEDIATE v_SqlString;