频道栏目
IT货架 > > 正文
CanoneusedynamicSQLstatementsfromPL/SQL?
网友分享于:Jun 13, 2018 12:03:01 AM    来源: IT货架   

Starting from Oracle8i one can use the "EXECUTE IMMEDIATE" statement to execute dynamic SQL and PL/SQL statements (statements created at run-time). Look at these examples. Note that the statements within quotes are NOT semicolon terminated:

One can also use the older DBMS_SQL package (V2.1 and above) to execute dynamic statements. Look at these examples:

More complex DBMS_SQL example using bind variables:

广告服务联系QQ:1134687142 | 网站地图

版权所有: IT货架- 内容来自互联网,仅供用于技术学习,请遵循相关法律法规. 京ICP备11030978号-1