oraclePLSQL语法详细手册.docx资源-CSDN文库

版权申诉

167 浏览量 2022-04-27 10:11:13 上传评论收藏 70KB DOCX 举报

资源推荐

资源详情

资源评论

SQL PL/SQL 语法手册


目   录
第一部分 SQL 语法部分.................................................................................................................................................3
一、 CREATE TABLE 语句..............................................................................................................................3
二、 CREATE SEQUENCE 语句........................................................................................................................5
三、 CREATE VIEW 语句................................................................................................................................6
四、 INSERT 语句:.......................................................................................................................................7
五、 UPDATE 语句:.....................................................................................................................................9
六、 DELETE 语句:...................................................................................................................................10
七、 TRUNCATE 语句:..............................................................................................................................11
八、 各类 FUNCTIONS:................................................................................................................................12
1. 
转换函数
:.......................................................................................................12
2. 
日期函数
........................................................................................................ 17
3. 
字符函数
........................................................................................................ 21
4. 
数值函数
........................................................................................................ 29
5. 
单行函数
:.......................................................................................................34
6. 
多行函数
........................................................................................................ 36
第二部分 PL/SQL 语法部分....................................................................................................................... .................43
一、 PL/SQL 语言简介..............................................................................................................................43
二、 变量说明............................................................................................................................................50
三、 PL/SQL 控制程序流..........................................................................................................................54
四、 存储过程............................................................................................................................................57
五、 存储函数............................................................................................................................................57
六、 PACKAGE.............................................................................................................................................57
七、 触发器................................................................................................................................................60
八、 应用实例............................................................................................................................................62
