Why DDL will not

最新推荐文章于 2022-10-27 17:24:42 发布

转载最新推荐文章于 2022-10-27 17:24:42 发布 · 77 阅读

本文探讨了数据库中DML（数据操作语言）游标和DDL（数据定义语言）游标的区别。DML游标可以被共享使用，而DDL游标则是在程序全局区（PGA）中内置且不被共享；它们在各自的解析阶段执行。

Only DML cursors (selects, inserts, updates, and deletes) are shared. DDL cursors are
built in the PGA and therefore are not shared; to be more precise, they execute within
their own parse phase. This is based upon the premise that DDL is typically executed
once.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/13750068/viewspace-730868/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13750068/viewspace-730868/