oracle 12c 做了很大的改变，集成了sqldeveloper,可以方便大家的使用，scott用户已经被移除了，需要的话可以自己创建，并授予权限。这个稍微有点基础的话都是很简单的……按着步骤来就可以
开始介绍下过程。
1.开始——运行——cmd
输入：sqlplus/ as sysdba连接到
2.创建#scott用户
1createuserc##scott identifiedbytiger ;
3.为用户授权
1grantconnect,resource,unlimited tablespacetoc##scott container=all;
4.设置用户使用的表空间
2alteruserc##scottdefaulttablespace users;
alteruserc##scotttemporarytablespacetemp;
5.使用c##scott用户登录
1connectc##scott/tiger
6.删除数据表
4droptableemp purge ;
droptabledept purge ;
droptablebonus purge ;
droptablesalgrade purge ;
7.创建数据表
createtabledept (
deptno number(2)constraintpk_deptprimarykey,
dname varchar2(14) ,
loc varchar2(13) ) ;
createtableemp (
empno number(4)constraintpk_empprimarykey,
ename varchar2(10),
job varchar2(9),
mgr number(4),
hiredatedate,
sal number(7,2),
comm number(7,2),
deptno number(2)constraintfk_deptnoreferencesdept );
createtablebonus (
ename varchar2(10) ,
job varchar2(9) ,
sal number,
comm number ) ;
createtablesalgrade (
grade number,
losal number,
hisal number );
8.插入测试数据——dept
4insertintodeptvalues(10,’accounting’,’new york’);
insertintodeptvalues(20,’research’,’dallas’);
insertintodeptvalues(30,’sales’,’chicago’);
insertintodeptvalues(40,’operations’,’boston’);
9.插入测试数据——emp
14insertintoempvalues(7369,’smith’,’clerk’,7902,to_date
(’17-12-1980′,’dd-mm-yyyy’),800,null,20);
insertintoempvalues(7499,’allen’,’salesman’,7698,to_date
(’20-2-1981′,’dd-mm-yyyy’),1600,300,30);
insertintoempvalues(7521,’ward’,’salesman’,7698,to_date
(’22-2-1981′,’dd-mm-yyyy’),1250,500,30);
insertintoempvalues(7566,’jones’,’manager’,7839,to_date
(‘2-4-1981′,’dd-mm-yyyy’),2975,null,20);
insertintoempvalues(7654,’martin’,’salesman’,7698,to_date
(’28-9-1981′,’dd-mm-yyyy’),1250,1400,30);
insertintoempvalues(7698,’blake’,’manager’,7839,to_date
(‘1-5-1981′,’dd-mm-yyyy’),2850,null,30);
insertintoempvalues(7782,’clark’,’manager’,7839,to_date
(‘9-6-1981′,’dd-mm-yyyy’),2450,null,10);
insertintoempvalues(7788,’scott’,’analyst’,7566,to_date
(’19-04-1987′,’dd-mm-yyyy’)-85,3000,null,20);
insertintoempvalues(7839,’king’,’president’,null,to_date
(’17-11-1981′,’dd-mm-yyyy’),5000,null,10);
insertintoempvalues(7844,’turner’,’salesman’,7698,to_date
(‘8-9-1981′,’dd-mm-yyyy’),1500,0,30);
insertintoempvalues(7876,’adams’,’clerk’,7788,to_date
(’23-05-1987′,’dd-mm-yyyy’)-51,1100,null,20);
insertintoempvalues(7900,’james’,’clerk’,7698,to_date
(‘3-12-1981′,’dd-mm-yyyy’),950,null,30);
insertintoempvalues(7902,’ford’,’analyst’,7566,to_date
(‘3-12-1981′,’dd-mm-yyyy’),3000,null,20);
insertintoempvalues(7934,’miller’,’clerk’,7782,to_date
(’23-1-1982′,’dd-mm-yyyy’),1300,null,10);
10.插入测试数据——salgrade
5insertintosalgradevalues(1,700,1200);
insertintosalgradevalues(2,1201,1400);
insertintosalgradevalues(3,1401,2000);
insertintosalgradevalues(4,2001,3000);
insertintosalgradevalues(5,3001,9999);
11.事务提交
1commit;