Oracle Database 10g基础教程(第二版)PPT和示例代码 --代码部分.docVIP

create table emp_history( empno integer, total_pay integer, update_date date); insert into emp_history values(1, 100, 08-6??-2006); insert into emp_history values(2, 200, 15-6??-2006); create table emp_history_adds( empno integer, net_pay integer); insert into emp_history_adds values(1, 150); insert into emp_history_adds values(3, 300); select * from emp_history; select * from emp_history_adds; merge into emp_history eh using emp_history_adds eha on (eh.empno = eha.empno) when matched then update set eh.total_pay = _pay, eh.update_date = 08-8??-2008; create table names( name varchar2(30)); insert into names values (q[Johnsonss book is very good.]); select * from names where name = qXJohnsonss book is very good.X; create tablespace mydb_tbs datafile /ora100/oracle/mydb/mydb_tbs_01.dbf size 100m; create rollback segment tbs_rs01 tablespace mydb_tbs storage (initial 100k next 100k minextents 10 optimal 1000k); create tablespace my_tbs datafile ora100/oracle/mydb/mydb_tbs_001.dbf size 100m; alter database add logfile group 4 (c:\oracle\oradata\mydb\mydb_logfile_group4_1_a.log, d:\oracle\oradata\mydb\mydb_logfile_group4_1_b.log) size 100m; 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 10