oracle12c创建scott账户及该账户下的四张表

最新推荐文章于 2024-06-17 18:25:20 发布

转载最新推荐文章于 2024-06-17 18:25:20 发布 · 739 阅读

文章标签：

#oracle12 #scott

java 专栏收录该内容

33 篇文章

订阅专栏

本文介绍如何在Oracle12c中创建scott用户并授予必要的权限，包括设置表空间、创建示例表及插入数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle 12c如何创建scott用户

Oracle 12C 做了很大的改变，集成了SQL Developer,可以方便大家的使用，scott用户已经被移除了，需要的话可以自己创建，并授予权限。

按照以下步骤即可完成：

[sql] view plain copy
1.进入cmd命令窗口，连接oracle数据库
sqlplus / as sysdba
2.创建c##scott用户(这里创建的用户为:c##scott，密码为:tiger)
create user c##scott identified by tiger
3.为用户授权
grant connect,resource,unlimited tablespace to c##scott container=all;

[sql] view plain copy
4.设置用户使用的表空间
alter user c##scott default tablespace users;
alter user c##scott temporary tablespace temp;
5.使用c##scott用户登录
connect c##scott/tiger
6.显示当前登录的用户
show user

使用SQL Developer创建连接，并使用c##scott用户登录

将以下创建表及其插入表中数据的sql语句执行。记得最后 commit;语句

[sql] view plain copy
DROP TABLE DEPT;
CREATE TABLE DEPT
(DEPTNO NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,
DNAME VARCHAR2(14) ,
LOC VARCHAR2(13) ) ;
DROP TABLE EMP;
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);
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’);
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,’BLAKE’,’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-JUL-87’)-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-JUL-87’)-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);
DROP TABLE BONUS;
CREATE TABLE BONUS
(
ENAME VARCHAR2(10) ,
JOB VARCHAR2(9) ,
SAL NUMBER,
COMM NUMBER
) ;
DROP TABLE SALGRADE;
CREATE TABLE SALGRADE
( GRADE NUMBER,
LOSAL NUMBER,
HISAL NUMBER );
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;

大功告成。