sqlplus /nolog
– 使用超级管理员登录
CONN /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

==退出plus 重新登录一次

建议使用sql devploer 链接scott执行以下脚本。

– 创建数据表 CREATE TABLE dept ( deptno NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,dname VARCHAR2(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,deptno NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT ); CREATE TABLE bonus ( enamE VARCHAR2(10),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’,1600,300,30); INSERT INTO emp VALUES (7521,’WARD’,to_date(‘22-2-1981’,1250,500,30); INSERT INTO emp VALUES (7566,’JONES’,’MANAGER’,7839,to_date(‘2-4-1981’,2975,20); INSERT INTO emp VALUES (7654,’MARTIN’,to_date(‘28-9-1981’,1400,30); INSERT INTO emp VALUES (7698,’BLAKE’,to_date(‘1-5-1981’,2850,30); INSERT INTO emp VALUES (7782,’CLARK’,to_date(‘9-6-1981’,2450,10); INSERT INTO emp VALUES (7788,’SCOTT’,’ANALYST’,7566,to_date(‘13-07-87’,’dd-mm-yyyy’)-85,3000,20); INSERT INTO emp VALUES (7839,’KING’,’PRESIDENT’,to_date(‘17-11-1981’,5000,10); INSERT INTO emp VALUES (7844,’TURNER’,to_date(‘8-9-1981’,1500,30); INSERT INTO emp VALUES (7876,’ADAMS’,7788,’dd-mm-yyyy’)-51,1100,20); INSERT INTO emp VALUES (7900,’JAMES’,to_date(‘3-12-1981’,950,30); INSERT INTO emp VALUES (7902,’FORD’,20); INSERT INTO emp VALUES (7934,’MILLER’,7782,to_date(‘23-1-1982’,1300,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;