Windows2012下安装和配置Oracle BIEE12c
https://blog.csdn.net/weixin_40086974/article/details/93474086
Windows2012安装Weblogic12c
https://blog.csdn.net/weixin_40086974/article/details/93473395
Windows2012安装Oracle Database12c
https://blog.csdn.net/weixin_40086974/article/details/93472619
oracle笔记附件——建表脚本
https://blog.csdn.net/u012424148/article/details/90146466
--相关脚本: --使用超级管理员登录 conn SYS/chage_on_install AS SYSDBA; --创建c##scott用户 CREATE USER c##scott IDENTIFIED BY tiger; --为用户授权 GRANT CONNECT, RESOURCE, UNLIMITED TABLESPACE TO c##scott container = ALL; --设置用户使用的表空间 ALTER USER c##scott DEFAULT TABLESPACE USERS; ALTER USER c##scott TEMPORARY TABLESPACE temp; --使用c##scott用户登录 CONNECT c##scott/tiger --删除数据表 DROP TABLE emp PURGE; DROP TABLE dept PURGE; DROP TABLE bonus PURGE; DROP TABLE salgrade PURGE; --创建数据表 CREATE TABLE dept( deptno NUMBER(2) CONSTRAINT pk_dept PRIMARY KEY, dname VARCHAR(14), loc VARCHAR2(13) ); CREATE TABLE emp( empno NUMBER(4) CONSTRAINT pk_emp PRIMARY KEY, ename VARCHAR2(10), job VARCHAR2(9), mgr NUMBER(4), hiredate DATE, sal NUMBER(7, 2), comm NUMBER(7, 2), deptno NUMBER(2) CONSTRAINT fk_deptno REFERENCES dept ); CREATE TABLE bonus( ename VARCHAR2(10), job VARCHAR2(9), sal NUMBER, comm NUMBER ); CREATE TABLE salgrade( grade NUMBER, losal NUMBER, hisal NUMBER ); --插入测试数据 --dept INSERT INTO dept VALUES(10, 'ACCOUNTING', 'NEW YORK'); INSERT INTO dept VALUES(20, 'RESEARCH', 'DALLAS'); INSERT INTO dept VALUES(30, 'SALES', 'CHICAGO'); INSERT INTO dept VALUES(40, 'OPERATIONS', 'BOSTON'); --插入测试数据 --emp INSERT INTO emp VALUES(7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-12-1980', 'DD-MM-YYYY'), 800, NULL, 20); INSERT INTO emp VALUES(7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-2-1981', 'DD-MM-YYYY'), 1600, 300, 30); INSERT INTO emp VALUES(7521, 'WARD', 'SALESMAN', 7698, TO_DATE('22-2-1981', 'DD-MM-YYYY'), 1250, 500, 30); INSERT INTO emp VALUES(7566, 'JONES', 'MANAGER', 7839, TO_DATE('2-4-1981', 'DD-MM-YYYY'), 2975, NULL, 20); INSERT INTO emp VALUES(7654, 'MARTIN', 'SALESMAN', 7698, TO_DATE('28-9-1981', 'DD-MM-YYYY'), 1250, 1400, 30); INSERT INTO emp VALUES(7698, 'BLANK', 'MANAGER', 7839, TO_DATE('1-5-1981', 'DD-MM-YYYY'), 2850, NULL, 30); INSERT INTO emp VALUES(7782, 'CLARK', 'MANAGER', 7839, TO_DATE('9-6-1981', 'DD-MM-YYYY'), 2450, NULL, 10); INSERT INTO emp VALUES(7788, 'SCOTT', 'ANALYST', 7566, TO_DATE('13-07-87', 'DD-MM-YYYY') - 85, 3000, NULL, 20); INSERT INTO emp VALUES(7839, 'KING', 'PRESIDENT', NULL, TO_DATE('17-11-1981', 'DD-MM-YYYY'), 5000, NULL, 10); INSERT INTO emp VALUES(7844, 'TURNER', 'SALESMAN', 7698, TO_DATE('8-9-1981', 'DD-MM-YYYY'), 1500, 0, 30); INSERT INTO emp VALUES(7876, 'ADAMS', 'CLERK', 7788, TO_DATE('13-07-87', 'DD-MM-YYYY') - 51, 1100, NULL, 20 ); INSERT INTO emp VALUES(7900, 'JAMES', 'CLERK', 7698, TO_DATE('3-12-1981', 'DD-MM-YYYY'), 950, NULL, 30); INSERT INTO emp VALUES(7902, 'FORD', 'ANALYST', 7566, TO_DATE('3-12-1981', 'DD-MM-YYYY'), 3000, NULL, 20); INSERT INTO emp VALUES(7934, 'MILLER', 'CLERK', 7782, TO_DATE('23-1-1982', 'DD-MM-YYYY'), 1300, NULL, 10); --插入测试数据 --salgrade INSERT INTO salgrade VALUES(1, 700, 1200); INSERT INTO salgrade VALUES(2, 1201, 1400); INSERT INTO salgrade VALUES(3, 1401, 2000); INSERT INTO salgrade VALUES(4, 2001, 3000); INSERT INTO salgrade VALUES(5, 3001, 9999); COMMIT; SELECT * FROM salgrade;