declare
x number(10);
str varchar2(100);
begin
x:=10;
str:='alter table table1 add (kyc number(20))'; ---这一行错误了.
execute immediate str;
end;
x number(10);
str varchar2(100);
begin
x:=10;
str:='alter table table1 add (kyc number(20))'; ---这一行错误了.
execute immediate str;
end;
nSQL NUMBER;
begin
sqlcmd :='alter table table1 add (kyc number(20))';
nSQL := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE( nSQL, sqlcmd, DBMS_SQL.v7 )