Oracle_ProC编程入门 - 墨天轮文档

Oracle_ProC编程入门

张怀亮

553

20页

2次

2019-12-30

5墨值下载

Oracle Pro*C 编程入门

易初电子有限公司第 1 页共 20 页

Oracle Pro*C 编程入门

研发中心

刘小强

Oracle Pro*C 编程入门

易初电子有限公司第 2 页共 20 页

1 引言...........................................................................................................................................3

1.1 编写目的...................................................................................................................3

1.2 编写背景...................................................................................................................3

1.3 参考资料...................................................................................................................3

2 Pro*C简介 ................................................................................................................................3

3 预编译与编译...........................................................................................................................4

3.1 例程...........................................................................................................................4

3.2 编译过程...................................................................................................................4

3.3 Pro*C头文件和库文件.............................................................................................4

3.4 编译过程举例...........................................................................................................4

3.5 Oracle预编译选项配置文件。 ................................................................................4

4 Pro*C语法结构 ........................................................................................................................6

4.1 嵌入SQL语句在程序中的标志。 ...........................................................................6

4.2 换行...........................................................................................................................6

4.3 程序结构...................................................................................................................6

4.4 程序中对数据库的连接...........................................................................................6

4.5 嵌入PL/SQL块 .........................................................................................................7

4.6 大小写.......................................................................................................................7

4.7 嵌入的SQL语句分类 ...............................................................................................7

4.8 宿主变量...................................................................................................................8

4.9 预编译选项配置文件...............................................................................................8

4.10 伪数据类型...............................................................................................................9

4.11 注释...........................................................................................................................9

4.12 换行...........................................................................................................................9

4.13 游标的使用。...........................................................................................................9

4.14 WHENEVER语句。 ..............................................................................................11

4.15 事务处理语句.........................................................................................................12

5 动态SQL .................................................................................................................................12

5.1 Oracle方法..............................................................................................................13

5.1.1 动态SQL语句的处理过程 .............................................................................13

5.1.2 Oracle使用动态SQL的四种方法...................................................................13

5.2 ANSI方法 ...............................................................................................................16

5.2.1 使用ANSI方法的一些注意事项....................................................................16

5.2.2 ANSI方法和Oracle方法的不同.....................................................................16

5.2.3 ANSI处理方法对动态SQL语句的处理步骤 ................................................16

5.2.4 程序举例.........................................................................................................17

of 20

5墨值下载

oracle 性能优化

关注

评论