可以啊,注意要加空格: TXTSQL1:='INSERT INTO ABC(A1) '||TXTSQL ; ---
CREATE OR REPLACE PROCEDURE PROC_ABCD (txtsql varchar2) IS TXTSQL1 VARCHAR2(1000); --要去掉declare begin TXTSQL1:='INSERT INTO ABC(A1) '||TXTSQL ; 运行TXTSQL1语句; end;
CREATE OR REPLACE PROCEDURE PROC_ABCD (txtsql varchar2) IS TXTSQL1 VARCHAR2(1000); --要去掉declare begin TXTSQL1:='INSERT INTO ABC (A1) values('||TXTSQL||')' ; execute immediate TXTSQL1; end;
TXTSQL1:='INSERT INTO ABC(A1) '||TXTSQL ;
---
IS
TXTSQL1 VARCHAR2(1000); --要去掉declare
begin
TXTSQL1:='INSERT INTO ABC(A1) '||TXTSQL ;
运行TXTSQL1语句;
end;
IS
TXTSQL1 VARCHAR2(1000); --要去掉declare
begin
TXTSQL1:='INSERT INTO ABC (A1) values('||TXTSQL||')' ;
execute immediate TXTSQL1;
end;