oracle从入门到精通.docx

oracle从入门到精通.docx

《oracle从入门到精通.docx》由会员分享，可在线阅读，更多相关《oracle从入门到精通.docx（154页珍藏版）》请在冰豆网上搜索。

oracle从入门到精通

oracle从入门到精通:

原文信息

Oracle从入门到精通

一、SQL...........................................................................................................................................................8

1.1、基本概念：

...................................................................................................................................8

1.2、数据库安全：

...............................................................................................................................8

1.3、基本的SQLSELECT语句.............................................................................................................8

1.4、SELECT语句...................................................................................................................................9

1、语法：

.......................................................................................................................................9

2、SQL语句说明：

.........................................................................................................................9

3、数字和日期都可以使用数学运算符建立表达式。

...............................................................9

4、定义空（NULL）值...................................................................................................................9

5、别名...........................................................................................................................................9

6、spool+路径...........................................................................................................................10

7、连接操作符：

||...................................................................................................................10

8、文本字符串.............................................................................................................................10

9、DISTINCT.................................................................................................................................10

1.5、SQLPLUS与SQL的关系...........................................................................................................10

1、SQLPLUS命令的功能：

...........................................................................................................10

2、查询SQLPLUS命令...............................................................................................................10

3、SQLPLUSW在WINDOWS下运行的分析器。

.........................................................................10

4、SQLPLUS命令：

.....................................................................................................................11

1.6、单行函数.....................................................................................................................................12

1、character字符类型函数：

...................................................................................................12

2、number数字类型函数.............................................................................................................15

3、时间类型函数：

（date）.......................................................................................................15

1.7、嵌套函数：

..................................................................................................................................21

1.通用函数：

.......................................................................................................................21

2.条件表达式：

...................................................................................................................24

3.从多表中显示数据：

.......................................................................................................25

1.8、用字函数产生的总计.................................................................................................................26

1.9、子查询：

.....................................................................................................................................28

2.0、替换变量：

.................................................................................................................................29

1.&.................................................................................................................................................29

2.&&...............................................................................................................................................29

2.1.环境变量：

...................................................................................................................................29

2.2格式化命令：

................................................................................................................................30

2.3做脚本文件的过程：

....................................................................................................................31

2.3数据操作语句：

............................................................................................................................31

1.插入..............................................