Oracle 数据库体系结构图(分享自eygel)

Oracle10gR2系统结构图 Oracle11g体系结构图 … [Read more...]

demobld.sql和demodrop.sql整理

 $ORACLE_HOME/sqlplus/demo/demobld.sql在10g中已经没有了,从9i中复制了出来。 [cce] -- -- Copyright (c) Oracle Corporation 1988, 2000. All Rights Reserved. -- -- NAME -- demobld.sql -- -- DESCRIPTION -- This script creates the SQL*Plus demonstration tables in the -- current schema. It should be STARTed by each user wishing to -- access the tables. To remove the tables use the demodrop.sql -- script. -- -- USAGE -- From within SQL*Plus, enter: -- START demobld.sql SET TERMOUT ON PROMPT Building demonstration tables. Please wait. SET TERMOUT OFF DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE BONUS; DROP TABLE SALGRADE; DROP TABLE DUMMY; CREATE TABLE EMP   (EMPNO NUMBER(4) NOT NULL,   ENAME VARCHAR2(10),   JOB VARCHAR2(9),   MGR NUMBER(4),   HIREDATE DATE,   SAL NUMBER(7, 2),   COMM NUMBER(7, 2),   DEPTNO NUMBER(2)); INSERT INTO EMP VALUES   (7369, 'SMITH', 'CLERK', 7902,   TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, … [Read more...]