Oracle Database 10g基础教程(第二版)PPT和示例代码
) >= 2000;
select empno, ename, deptno, hiredate, sal from emp;
select deptno, dname, loc from dept;
select ename, dname, hiredate, sal, loc
from emp, dept;
select ename, dname, hiredate, sal, loc
from emp, dept
where emp.deptno = dept.deptno;
select ename, d.deptno, dname
from emp e, dept d
where e.deptno(+) = d.deptno
order by ename;
select worker.ename || '的经理是' || manager.ename
from emp worker, emp manager
where worker.mgr = manager.empno;
select empno, ename
from emp
where ename like 'A%' or ename like 'B%'
union
select empno, ename
from emp
where ename like 'B%' or ename like 'C%';
select empno, ename
from emp
where ename like 'A%' or ename like 'B%'
union all
select empno, ename
from emp
where ename like 'B%' or ename like 'C%';
select empno, ename
from emp
where ename like 'A%' or ename like 'B%'
intersect
select empno, ename
from emp
where ename like 'B%' or ename like 'C%';
select empno, ename
from emp
where ename like 'A%' or ename like 'B%'
minus
select empno, ename
from emp
where ename like 'B%' or ename like 'C%';
desc dept
insert into dept
values(50, 'Office', 'Hong Kong');
select *
from dept;
insert into dept
values(&deptNo, &deptName, &deptLocation);
select empno, ename, deptno
from emp
where ename like 'C%';
update emp
set deptno = 20
where empno = 7782;
update emp
set deptno = 55
where deptno = 20;
select *
from dept;
delete from dept
where deptno = 50 or deptno = 60;
select sal
from emp
where ename = 'CLARK';
select empno, ename, job, hiredate, sal
from emp
where sal > (select sal
from emp
where ename = 'CLARK');
select empno, ename, job, hiredate, sal
from emp
where job = (select job
from emp
where empno = 7369);
select empno, ename, job, hiredate, sal
from emp
where sal = (select max(sal) from emp)
or sal = (select min(sal) from emp);
select max(sal)
from emp
group by deptno;
select ename, deptno, job, hiredate, sal
from emp
where sal = (select max(sal)
from emp
group by deptno);
select max(sal)
from emp
group by deptno;
select ename, deptno, job, hiredate, sal
from emp
where sal in (select max(sal)
from emp
group by deptno);
select ename, job, hiredate, sal, deptno
from emp
where (sal, nvl(comm, -1)) in (select sal, nvl(comm, -1)
from emp
where deptno = 20);
select empno, ename, job, deptno
from emp
where empno = 7499 or empno = 7782;
update emp
set (job, deptno) = (select job, deptno
from emp
where empno = 7499)
where empno = 7782;
select a.ename, a.deptno, a.sal, b.avgsalary
from emp a, (select deptno, avg(sal) as avgsalary
from emp
group by deptn
Oracle Database 10g基础教程(第二版)PPT和示例代码10_IT/计算机_专业资料。Oracle Database 10g基础教程(第二版)PPT和示例代码create table bookTitle( title ...
Oracle Database 10g基础教程(第二版)PPT和示例代码Oracle Database 10g基础教程(第二版)PPT和示例代码隐藏>> set serveroutput on declare example_text varchar2...
Oracle Database 10g基础教程(第二版)PPT和示例代码Oracle Database 10g基础教程(第二版)PPT和示例代码隐藏>> select ename, hiredate from emp where ename like...
Oracle Database 10g基础教程(第二版)PPT和示例代码Oracle Database 10g基础教程(第二版)PPT和示例代码隐藏>> connect system/manager create user oracle_admin ...
Oracle Database 10g基础教程(第二版)PPT和示例代码Oracle Database 10g基础教程(第二版)PPT和示例代码隐藏>> connect system/manager grant dba to scott; ...
搜 试试 7 帮助 全部 DOC PPT TXT PDF XLS ...? Oracle Database 10g基础教程(第二版) 第6章 .../SQL语言编写在数据库中执行 的定制程序和过程代码...
格式:ppt 关键词:教材 1/2 相关文档推荐... 清华大学出版社,Oracle Database 10g基础教程。清华...这 些信息包括SQL*Plus的环境设置、 PL/SQL代码、...
PL/SQL代码使用了程序块,利用模块化方式进 行构建。第9章 PL/SQL基础 Oracle Database 10g基础教程(第二版) 第6页 示例程序块 Oracle Database 10g基础教程(第...
格式:ppt 关键词:暂无1/2 相关文档推荐 oracle...许多开发人员都非常重视开发模块化代码。用户通过编写...示例 Oracle Database 10g基础教程(第二版) 第13章...
oracle_database_10g教程2_IT/计算机_专业资料。...一个进程执行 全部的Oracle代码,即服务进程与客户...了关于数据库本身以及 其中存储的所有对象的基本信息...
热门文档