05.txt

Oracle database 10g基础教程（第二版） 源码

column ename heading '雇员姓名' format A15
column sal heading '薪水' justify center format $99,999.00
column comm heading '红利' justify right format $99,999.00 NULL '无'
column hiredate heading '聘用日期'
select ename, sal, comm, hiredate
from emp;
 


ttitle '雇员薪水清单'
btitle '------Tom科技发展有限公司------'
select empno, ename, sal
from emp;



select empno, ename, sal, job
from emp;


set pagesize 20
select empno, ename, sal, job
from emp;



show linesize
select * 
from emp;



set linesize 160
select *
from emp;




show feedback
select *
from emp;



select *
from emp
where rownum < 6;







create table t1(colName number);
insert into t1 values(1234567890);
insert into t1 values(12345678901);
insert into t1 values(12345678901234567890);
select *
from t1;


set numformat 9999999999999999999999999999999.999999999999999


select text
from all_views
where view_name = 'USER_TABLES';

set pagesize 1000
set long 10000
/



describe emp
desc dept

desc dbms_output




select ename, sal, job, hiredate
from emp
where sal > &amount;


select empno, ename, &columnName, job
from &tableName
where &condition
order by &orderColumnName;


select empno, ename, job, &columnName
from emp
where sal >= 3000
order by &columnName;

select empno, ename, job, &&columnName
from emp
where sal >= 3000
order by &columnName;



define deptName = "sales"
define deptName
select *
from dept
where dname = upper('&deptName');



accept deptName prompt '请输出部门名称：'
select *
from dept
where dname = upper('&deptName');



create or replace procedure show_emp(p_empno in number)
is 
begin
    for c1 in (select * from emp where empno = p_empno) loop
    dbms_output.put_line('Name:'||c1.ename);
    dbms_output.put_line('Job:'||c1.job);
    dbms_output.put_line('Salary:'||c1.sal);
    dbms_output.put_line('Commission:'||c1.comm);
end;
end show_emp;
/
show errors




select ename, job, hiredate, salary
from dmp;


spool outputFile.txt
select empno, ename, job, mgr, hiredate, sal from emp where sal >= 2500;
spool off
spool outputFile.txt append
select empno, ename, job, mgr, hiredate, sal from emp where sal >= 3000;




ttitle '员工薪水清单  报告日期：' _date
select empno, ename, job, hiredate, sal
from emp
where sal >= 2500;