mutourenoo
- 浏览: 201495 次
- 性别:
- 来自: 上海
-
文章分类
- 全部博客 (196)
- Git (16)
- maven (8)
- Python (20)
- linux (14)
- java (30)
- spring (5)
- javascript (4)
- oracle (15)
- jquery (4)
- jbpm4.4 (4)
- ibatis (1)
- svn (1)
- sql server (1)
- sqoop (1)
- photoshop (2)
- 日常记录 (5)
- scala (1)
- IntelliJ IDEA (7)
- mysql (2)
- Hive (1)
- visual studio code (3)
- angularjs (5)
- nodejs (4)
- gradle (1)
- springboot (4)
- jakson (1)
- hibernate (2)
- 面试 (5)
- React (2)
- Kotlin (1)
- Netty (0)
- webstorm (2)
- spring cloud (4)
- redis (1)
- PowerDesigner (1)
- Vue (4)
- easyui (1)
- activiti (2)
- httpClient4.5 (2)
- logback (3)
- ngrinder (1)
- 分库分表 (1)
最新评论
-
严东军：
学习了，谢谢
摘录--DBMS_SCHEDULER -
zwllxs：
你知道你调的是谁的代码不?
jbpm4.4+ssh2 完整请假流程
-----------------------------------------------视图 view （用来封装复杂的查询语句）
SQL> create or replace view myview ---创建视图
2 as
3 select * from emp;
View created
SQL> select * from myview; -----查询视图
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
14 rows selected
SQL> insert into myview(empno,ename) values(1,'liwu'); ----插入一条记录后，查询视图和表，结果一样
1 row inserted
SQL> select * from myview;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
1 liwu
15 rows selected
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
1 liwu
15 rows selected
-------------------------------------------------------------------------------------------
SQL> create or replace view myview ----创建视图 此视图有where条件
2 as
3 select * from emp where sal <1000;
View created
SQL> select * from myview;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
SQL> insert into myview values(2,'abcd');
insert into myview values(2,'abcd')
ORA-00947: not enough values ----插入报错，说明有where条件的视图，插入时要把字段写全
SQL> insert into myview values(8000,'john','java',null,null,6000,null,10);
1 row inserted
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
1 liwu
8000 john java 6000.00 10
17 rows selected
SQL> select * from myview; ---视图结果没有显示插入的记录是因为视图中的where条件
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7999 john java 600.00 20
-------------------------------------------------------------------------------------
SQL> create or replace view myview
2 as
3 select * from dept where deptno >30
4 with check option ; ------创建视图时添加此限制语句，在视图添加操作时判断是否满足视图里面的where条件
View created
SQL> select * from myview;
DEPTNO DNAME LOC
------ -------------- -------------
40 OPERATIONS BOSTON
SQL> insert into myview values(5,'test','sss'); ----视图插入记录 不满足where条件
insert into myview values(5,'test','sss')
ORA-01402: view WITH CHECK OPTION where-clause violation ----报错
----------------------------------------------------------------------------
SQL> select e.empno,e.ename,d.dname,d.loc from emp e,dept d where e.deptno = d.deptno;
EMPNO ENAME DNAME LOC
----- ---------- -------------- -------------
7369 SMITH RESEARCH DALLAS
7499 ALLEN SALES CHICAGO
7521 WARD SALES CHICAGO
7566 JONES RESEARCH DALLAS
7654 MARTIN SALES CHICAGO
7698 BLAKE SALES CHICAGO
7782 CLARK ACCOUNTING NEW YORK
7788 SCOTT RESEARCH DALLAS
7839 KING ACCOUNTING NEW YORK
7844 TURNER SALES CHICAGO
7876 ADAMS RESEARCH DALLAS
7900 JAMES SALES CHICAGO
7902 FORD RESEARCH DALLAS
7934 MILLER ACCOUNTING NEW YORK
8000 john ACCOUNTING NEW YORK
15 rows selected
SQL> create or replace view v_emp_dept -----创建视图封装查询语句
2 as
3 select e.empno,e.ename,d.dname,d.loc from emp e,dept d where e.deptno = d.deptno;
View created
SQL> select * from v_emp_dept;
EMPNO ENAME DNAME LOC
----- ---------- -------------- -------------
7369 SMITH RESEARCH DALLAS
7499 ALLEN SALES CHICAGO
7521 WARD SALES CHICAGO
7566 JONES RESEARCH DALLAS
7654 MARTIN SALES CHICAGO
7698 BLAKE SALES CHICAGO
7782 CLARK ACCOUNTING NEW YORK
7788 SCOTT RESEARCH DALLAS
7839 KING ACCOUNTING NEW YORK
7844 TURNER SALES CHICAGO
7876 ADAMS RESEARCH DALLAS
7900 JAMES SALES CHICAGO
7902 FORD RESEARCH DALLAS
7934 MILLER ACCOUNTING NEW YORK
8000 john ACCOUNTING NEW YORK
15 rows selected
两个基表或以上的查询语句组成的试图是不能够进行 视图的增操作的或其他操作，
解决办法是 利用oracle的替代触发器
----------------------------------------------------------------------------------
SQL> create or replace view v_read ---创建视图
2 as
3 select * from dept
4 with read only; -----限制语句，此视图为只读的，有的视图里面的查询语句虽然没有此限制语句但是select语 句中有group by ,distinct等函数，那么视图也是只读的，不能修改
View created
--------------------------------------------
SQL> create sequence myseq -----创建序列sequence
2 start with 1 --从几开始
3 increment by 1 --递增
4 order --排序
5 nocycle; --不循环
Sequence created
SQL> select myseq.nextval from dual;
NEXTVAL
----------
1
SQL> select myseq.nextval from dual;
NEXTVAL
----------
2
SQL> select myseq.nextval from dual; --查询下一个序列值
NEXTVAL
----------
3
SQL> select myseq.currval from dual; --查询当前的序列值
CURRVAL
----------
3
SQL> alter sequence myseq ---修改序列的递增值 可以修改递增量，但不能修改当前的序列值
2 increment by 3;
Sequence altered
SQL> select myseq.nextval from dual;
NEXTVAL
----------
6
SQL> select myseq.nextval from dual;
NEXTVAL
----------
9
SQL> select myseq.nextval from dual;
NEXTVAL
----------
12
SQL> create or replace view myview ---创建视图
2 as
3 select * from emp;
View created
SQL> select * from myview; -----查询视图
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
14 rows selected
SQL> insert into myview(empno,ename) values(1,'liwu'); ----插入一条记录后，查询视图和表，结果一样
1 row inserted
SQL> select * from myview;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
1 liwu
15 rows selected
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
1 liwu
15 rows selected
-------------------------------------------------------------------------------------------
SQL> create or replace view myview ----创建视图 此视图有where条件
2 as
3 select * from emp where sal <1000;
View created
SQL> select * from myview;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
SQL> insert into myview values(2,'abcd');
insert into myview values(2,'abcd')
ORA-00947: not enough values ----插入报错，说明有where条件的视图，插入时要把字段写全
SQL> insert into myview values(8000,'john','java',null,null,6000,null,10);
1 row inserted
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
1 liwu
8000 john java 6000.00 10
17 rows selected
SQL> select * from myview; ---视图结果没有显示插入的记录是因为视图中的where条件
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7999 john java 600.00 20
-------------------------------------------------------------------------------------
SQL> create or replace view myview
2 as
3 select * from dept where deptno >30
4 with check option ; ------创建视图时添加此限制语句，在视图添加操作时判断是否满足视图里面的where条件
View created
SQL> select * from myview;
DEPTNO DNAME LOC
------ -------------- -------------
40 OPERATIONS BOSTON
SQL> insert into myview values(5,'test','sss'); ----视图插入记录 不满足where条件
insert into myview values(5,'test','sss')
ORA-01402: view WITH CHECK OPTION where-clause violation ----报错
----------------------------------------------------------------------------
SQL> select e.empno,e.ename,d.dname,d.loc from emp e,dept d where e.deptno = d.deptno;
EMPNO ENAME DNAME LOC
----- ---------- -------------- -------------
7369 SMITH RESEARCH DALLAS
7499 ALLEN SALES CHICAGO
7521 WARD SALES CHICAGO
7566 JONES RESEARCH DALLAS
7654 MARTIN SALES CHICAGO
7698 BLAKE SALES CHICAGO
7782 CLARK ACCOUNTING NEW YORK
7788 SCOTT RESEARCH DALLAS
7839 KING ACCOUNTING NEW YORK
7844 TURNER SALES CHICAGO
7876 ADAMS RESEARCH DALLAS
7900 JAMES SALES CHICAGO
7902 FORD RESEARCH DALLAS
7934 MILLER ACCOUNTING NEW YORK
8000 john ACCOUNTING NEW YORK
15 rows selected
SQL> create or replace view v_emp_dept -----创建视图封装查询语句
2 as
3 select e.empno,e.ename,d.dname,d.loc from emp e,dept d where e.deptno = d.deptno;
View created
SQL> select * from v_emp_dept;
EMPNO ENAME DNAME LOC
----- ---------- -------------- -------------
7369 SMITH RESEARCH DALLAS
7499 ALLEN SALES CHICAGO
7521 WARD SALES CHICAGO
7566 JONES RESEARCH DALLAS
7654 MARTIN SALES CHICAGO
7698 BLAKE SALES CHICAGO
7782 CLARK ACCOUNTING NEW YORK
7788 SCOTT RESEARCH DALLAS
7839 KING ACCOUNTING NEW YORK
7844 TURNER SALES CHICAGO
7876 ADAMS RESEARCH DALLAS
7900 JAMES SALES CHICAGO
7902 FORD RESEARCH DALLAS
7934 MILLER ACCOUNTING NEW YORK
8000 john ACCOUNTING NEW YORK
15 rows selected
两个基表或以上的查询语句组成的试图是不能够进行 视图的增操作的或其他操作，
解决办法是 利用oracle的替代触发器
----------------------------------------------------------------------------------
SQL> create or replace view v_read ---创建视图
2 as
3 select * from dept
4 with read only; -----限制语句，此视图为只读的，有的视图里面的查询语句虽然没有此限制语句但是select语 句中有group by ,distinct等函数，那么视图也是只读的，不能修改
View created
--------------------------------------------
SQL> create sequence myseq -----创建序列sequence
2 start with 1 --从几开始
3 increment by 1 --递增
4 order --排序
5 nocycle; --不循环
Sequence created
SQL> select myseq.nextval from dual;
NEXTVAL
----------
1
SQL> select myseq.nextval from dual;
NEXTVAL
----------
2
SQL> select myseq.nextval from dual; --查询下一个序列值
NEXTVAL
----------
3
SQL> select myseq.currval from dual; --查询当前的序列值
CURRVAL
----------
3
SQL> alter sequence myseq ---修改序列的递增值 可以修改递增量，但不能修改当前的序列值
2 increment by 3;
Sequence altered
SQL> select myseq.nextval from dual;
NEXTVAL
----------
6
SQL> select myseq.nextval from dual;
NEXTVAL
----------
9
SQL> select myseq.nextval from dual;
NEXTVAL
----------
12
2
顶
顶
0
踩
踩
分享到：
发表评论
-
简历11111111111
2013-03-12 22:19 625简历的顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶 -
oracle集合操作函数
2010-09-13 10:34 1007集合操作符专门用于合并多条select 语句的结果，包括：UN ... -
摘录--DBMS_SCHEDULER
2010-08-11 16:24 1788Oracle 10g新增了scheduler的功能，功能比jo ... -
oracle的case语句实例
2010-08-09 13:12 905SELECT SUM( CASE ... -
摘录：简单测试job的创建过程案例
2010-08-04 18:37 1118一：简单测试job的创建 ... -
摘录-详解 Oracle job 的使用与管理技巧
2010-08-04 18:35 1102详解 Oracle job 的使用与管理技巧 SVRMGR&g ... -
摘录--关于MV刷新的问题
2010-08-04 10:56 1771关于MV刷新的问题 最近在工作中遇到一个问题，是关 ... -
转：基于远程数据库表，建立本地数据库的物化视图
2010-05-03 14:49 1990基于远程数据库表，建立本地数据库的物化视图2008年12月28 ... -
如何用SQL返回两个日期之间的所有连续日期
2010-04-06 22:28 8955如何用SQL返回两个日期之间的所有连续日期 -------- ... -
qlsql 学习实例代码4
2010-04-03 19:57 1076---------------------------行触发器 ... -
qlsql 学习实例代码2
2010-03-31 15:09 1195------------------------------- ... -
qlsql 学习实例代码1
2010-03-30 23:11 1154准备工作： create table DEPT ( DEP ... -
PL SQL 学习笔记
2010-03-30 15:47 812PL SQL 学习笔记 见附件 作者：丁俊 PLSDE ... -
oracle pl/sql实例练习
2010-03-30 12:11 1011第一部分：oracle pl/sql实例练习(1) 一、使用s ...
相关推荐
PLSQL综合实例PLSQL综合实例PLSQL综合实例PLSQL综合实例PLSQL综合实例。绝对经典。
PLSQL数据库编程 存储过程 游标 等等
plsql 实例plsql 实例plsql 实例plsql 实例
PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 PLSQL学习资料 ...
oracle plsql 代码入门到精通实例演示讲解，plsql编程入门教程
里面包括SQL基本语法。包含了PLSQL编程用到的所有实例。里面全部是例子，很好的东西。分享下。
ORACLE PLSQL实例精解(第4版) 中文版
Oracle 11g SQL和PLSQL源代码 Oracle 11g SQL和PLSQL源代码
plsql学习plsql学习plsql学习plsql学习plsql学习
plsql存储过程源代码
PLSQL Developer 操作学习文档 详细学习
Oracle® PL/SQL by Example，Oracle PLSQL实例精解，第4版，英文原版电子书。
高清pdf——ORACLE PLSQL实例精解(第4版) 拿去用不谢.
作为学习PLSQL学习的一些好资料。大家好好评价评价
Oracle PLSQL实例精解第4版英文版PDF和建库源码Oracle PLSQL实例精解第4版英文版PDF和建库源码
oracle plsql 实例 练习
plsql官方示例代码 学习plsql的基础使用 附带代码说明readme
PLSQL学习笔记(1-7),供大家一起学习。
PLSQL培训（二） PLSQL培训（一） oracle系列培训教材（PL-SQL）.doc PL SQL教程.pdf PLSQL基础.pdf plsql配置自动显示my object_陈慧兵.doc SQL21自学通.pdf SQL复制指南及参考.pdf SQL语句优化.doc SQL语言参考...