Oracle技术文档笔记

Oracle

Oracle --------------------------------------------------------------------------------------------------------------------- 1

Day01 --------------------------------------------------------------------------------------------------------------- 2

一.数据库的定义 ----------------------------------------------------------------------------------------- 2

二.数据库的操作 ----------------------------------------------------------------------------------------- 2

1.SQL 语言: Structured Query Language ------------------------------------------------------ 2

2.sqlplus 工具:Oracle 的客户端工具. --------------------------------------------------------- 2

1.SQL 语句: ------------------------------------------------------------------------------------------------- 4

2.SqlPlus 工具 ---------------------------------------------------------------------------------------------------- 5

.条件查询--------------------------------------------------------------------------------------------- 5

--用 in 实现------------------------------------------------------------------------------------------- 5

--like 表示模糊查询 -------------------------------------------------------------------------------- 6

--转译关键字 ---------------------------------------------------------------------------------------- 6

--事务控制关键字 ---------------------------------------------------------------------------------- 7

--update 语句语法 --------------------------------------------------------------------------------- 7

二.和日期相关的 sql 语句 ----------------------------------------------------------------------- 7

--常用函数与函数嵌套 --------------------------------------------------------------------------- 9

--驱动表和匹配表 -------------------------------------------------------------------------------- 13

--非等值连接. ------------------------------------------------------------------------------------- 14

三.子查询 ------------------------------------------------------------------------------------------------- 17

Day04 ------------------------------------------------------------------------------------------------------------- 18

一.子查询 ------------------------------------------------------------------------------------------------- 18

二.约束条件: constraint ------------------------------------------------------------------------------- 21

Day05 ------------------------------------------------------------------------------------------------------------- 24

一.事务 Transaction ----------------------------------------------------------------------------------- 24

--启动事务 ----------------------------------------------------------------------------------------- 24

--提交事务 ----------------------------------------------------------------------------------------- 25