Oracle Database 10g基础教程(第二版)PPT和示例代码
create table simpleTable(col number);
insert into simpleTable values(1);
insert into simpleTable values(2);
insert into simpleTable values(3);
select col
from simpleTable;
set serverout on;
begin
for cur1 in (select col
from simpleTable) loop
dbms_output.put_line(cur1.col || '是simpleTalbe表中的值。');
end loop;
end;
/
desc emp;
select empno, ename, job, hiredate
from emp;
select ename, hiredate, sal, comm
from emp;
select ename, job, comm, comm*2+250
from emp;
select ename as EmployeeName, sal Salary, deptno "Department Number"
from emp;
select ename, job, hiredate, sal
from emp
where job = 'CLERK';
select ename, job, hiredate, sal
from emp
where job = 'MANAGER';
select ename, job, hiredate, sal
from emp
where job = 'manager';
select ename, sal, hiredate, sal
from emp
where hiredate < '1-7月-81';
select ename, sal, hiredate, sal
from emp
where hiredate > '1-7月-81';
select ename, job, hiredate, sal
from emp
where ename like 'A%';
select ename, job, hiredate, sal
from emp
where ename like 'A\%' escape '\';
select ename, job, hiredate, sal
from emp
where sal between 1500 and 2500;
select ename, job, hiredate, sal
from emp
where sal >= 1500 and sal <= 2500;
select ename, job, hiredate, sal
from emp
where job = 'SALESMAN' or job = 'PRESIDENT' and sal > 1500;
select ename, job, hiredate, sal
from emp
where (job = 'SALESMAN' or job = 'PRESIDENT') and sal > 1500;
select ename, job, hiredate, sal
from emp
order by sal;
select ename, job, hiredate, sal
from emp
order by sal desc;
select ename, job, hiredate, sal, sal*12 YearSalary
from emp
order by sal*12 desc;
select ename, job, hiredate, sal
from emp
order by hiredate, sal desc;
select ename, job, hiredate, sal
from emp
order by 3, sal desc;
select sum(sal), avg(sal), sum(sal*12), avg(sal*12)
from emp;
select ename, deptno, sal, comm
from emp;
select count(ename), count(deptno), count(distinct deptno), count(sal), count(comm)
from emp;
select ename, nvl2(ename, 'HAVE NAME', 'NO NAME'), comm, nvl(comm, '0')
from emp;
select exp(1), exp(10), power(2.71828183, 10)
from dual;
select to_char(1234567.89, '009,999,999.9900'),
to_char(1234567.89, '999999.99EEEE'),
to_char(567, 'RN')
from dual;
select deptno, avg(sal), max(sal), min(sal)
from emp
group by deptno;
select avg(sal), max(sal), min(sal)
from emp
group by deptno;
select ename, avg(sal), max(sal), min(sal)
from emp
group by deptno;
select deptno, job, sum(sal), avg(sal)
from emp
group by deptno, job;
select job, deptno, sum(sal), avg(sal)
from emp
group by job, deptno;
select deptno, avg(sal)
from emp
where avg(sal) >= 2000
group by deptno;
select deptno, avg(sal)
from emp
group by deptno
having avg(sal
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代码,即服务进程与客户...了关于数据库本身以及 其中存储的所有对象的基本信息...
热门文档