动态SQL是将SQL语句先存为一个字符串,然后再执行:
example:declare
-- Local variables here
STR VARCHAR2(100);
HIT TGP_FUNDS%ROWTYPE;
begin
STR := 'select * from TGP_FUNDS'||' where '||'fnd_id=''MPGF''';
EXECUTE IMMEDIATE STR into hit;
DBMS_OUTPUT.put_line(HIT.FND_ID);
end;
example:declare
-- Local variables here
STR VARCHAR2(100);
HIT TGP_FUNDS%ROWTYPE;
begin
STR := 'select * from TGP_FUNDS'||' where '||'fnd_id=''MPGF''';
EXECUTE IMMEDIATE STR into hit;
DBMS_OUTPUT.put_line(HIT.FND_ID);
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货