- 博客(0)
- 资源 (9)
- 收藏
- 关注
oracle+proc中文.pdf
oracle+proc中文.pdf 1 前言 .................................................................................................................................................1
1.1 读者范围 .................................................................................................................................1
1.2 内容组织 .................................................................................................................................1
1.3 约定 .........................................................................................................................................1
2 新特性介绍......................................................................................................................................2
2.1 ORACIE9I RELEASE 2 (9.2) 新特性..........................................................................................2
2.2 ORACLE9I RELEASE 1 (9.0.1) 新特性......................................................................................2
2.3 ORACLE 8I RELEASEE 8.1.5 新特性.........................................................................................3
2.4 ORACLE 8I RELEASE 8.1.4 新特性...........................................................................................3
2.5 ORACLE 8I RELEASE 8.1.3 新特性...........................................................................................3
3 概述 .................................................................................................................................................3
3.1 什么是ORACLE预编译程序? ................................................................................................3
3.2 为什么使用ORACLE预编译程序? ........................................................................................4
3.3 为什么使用SQL?..................................................................................................................4
3.4 为什么使用PL/SQL? ............................................................................................................5
3.5 PRO*C预编译的优点..............................................................................................................5
3.6 常见的问题.............................................................................................................................6
3.6.1 我怎么编译链接应用程序? .........................................................................................6
3.6.2 什么是varchar?...............................................................................................................8
3.6.3 在什么情况下不使用Pro*C/C++和SQLLIB库函数?...............................................8
3.6.4 能在Pro*C/C++程序中调用存储过程吗?..................................................................8
3.6.5 我能在 SQL 语句的任意位置使用绑定变量(也可理解为用户自定义变量或输入
宿主变量)吗?..............................................................................................................................8
3.6.6 对Pro*C/C++字符类型变量的困惑?..........................................................................9
3.6.7 关于字符串指针变量的应用有特殊需要注意的么? .................................................9
3.6.8 为什么SPOOL不能用在Pro*C程序中? ........................................................................9
3.6.9 Pro*C/C++支持结构作为宿主变量么?..........................................................................9
3.6.10 可以在递归函数中嵌入SQL么? ..................................................................................10
3.6.11 我可以在任意版本的Oracle中使用任意版本的预编译器么?.................................10
3.6.12 1405 错误(Fetch column values is null)可避免么?...............................................10
4 预编译介绍....................................................................................................................................10
4.1 嵌入式SQL编程概念介绍....................................................................................................10
4.1.1 可嵌入Pro*C/C++的SQL语句....................................................................................10
4.1.2 嵌入SQL语句的语法格式............................................................................................ 11
4.1.3 静态和动态SQL语句....................................................................................................12
4.1.4 嵌入的PL/SQL语句块..................................................................................................12
4.1.5 宿主变量和指示变量...................................................................................................12
4.1.6 Oracle数据类型................................................................................................................13
4.1.7 数组 ...............................................................................................................................13
4.1.8 数据类型转换...............................................................................................................13
4.1.9 私有SQL工作区、游标和记录集................................................................................13
2013-03-29
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人