RE SECTION声明宿主变量EXEC SQL DECLARE给Oracle对像命名EXEC SQL INCLUDE从文件中复制EXEC SQL TYPE同等化数据类型EXEC SQL VAR同等化变量EXEC SQL WHENEVER处理运行时错误执行表达式EXEC SQL ALLOCATE声明、控制Oracle数据EXEC SQL ALTEREXEC SQL ANALYZEEXEC SQL AUDITEXEC SQL COMMENTEXEC SQL CONNECTEXEC SQL CREATEEXEC SQL DROPEXEC SQL GRANTEXEC SQL NOAUDITEXEC SQL RENAMEEXEC SQL REVOKEEXEC SQL TRUNCATEEXEC SQL CLOSEEXEC SQL DELETE排序、修改Oracle数据EXEC SQL EXPLAIN PLANEXEC SQL FETCHEXEC SQL INSERTEXEC SQL LOCK TABLEEXEC SQL OPENEXEC SQL SELECTEXEC SQL UPDATEEXEC SQL COMMIT处理事务EXEC SQL ROLLBACKEXEC SQL SAVEPOINTEXEC SQL SET TRANSACTIONEXEC SQL DESCRIBE使用动态SQLEXEC SQL EXECUTEEXEC SQL PREPAREEXEC SQL ALTER SESSION控制会话EXEC SQL SET ROLEEXEC SQL EXECUTE
END-EXEC内嵌PL/SQL块
This document was written originally by Ankur Jain and Jeff Ullman for CS145, Autumn 1997; revised by Jun Yang for Prof. Jennifer Widom''''s CS145 class in Spring, 1998; further revisions by Roy Goldman for Prof. Jeff Ullman''''s CS145 class in Autumn, 1999; further revisions by Calvin Yang for Prof. Jennifer Widom''''s CS145 class in Spring, 2002.
上一页 [1] [2] [3] |
