本文共 1870 字，大约阅读时间需要 6 分钟。

Oracle??????????????????

?Oracle????????????????????????????????????????????????????????

??????

1. ?????????

???????????????????

create user yc identified by a default tablespace ycspace temporary tablespace temp;

?????????yc???????a???????ycspace???????temp?

2. ??????

(1) ??????

??????????????

grant create session to yc;grant select on emp to yc;

(2) ??????

??????????

alter user yc identified by b grant create session to yc;

(3) ??????

????????

revoke create session from scott;

3. ??????????

(1) ???????

insert into emp values(7369, 'SMITH', 'CLERK', 7844, 10, 300, 20);

(2) ??????

???????

update emp set ename='YC' where empno=7369;

?????????????

1. ????????

create tablespace ycspace datafile 'E:\oracle\app\product\11.2.0\dbhome_1\oradata\ycspace.dbf' size 2m offline;

2. ????????

create temporary yctempspace tempfile 'E:\oracle\app\product\11.2.0\dbhome_1\oradata\ycspace.dbf' size 2m offline;

3. ???????

alter tablespace ycspace add datafile 'E:\oracle\app\product\11.2.0\dbhome_1\oradata\add.dbf' size 2m;

4. ???????

drop datafile 'E:\oracle\app\product\11.2.0\dbhome_1\oradata\add.dbf';

????????????

1. ????

(1) ????

select * from emp;select empno, ename from emp;select empno, ename, job from emp;

(2) ????

select job from emp;select distinct job from emp;select job, deptno from emp;select distinct job, deptno from emp;

2. ????

(1) ????

select * from emp where sal > 1500;select * from emp where comm is not null;select * from emp where comm is null;

(2) ????

select count(empno) from emp group by deptno;select deptno, job, count(*) from emp group by deptno order by deptno;

3. ????

update emp set sal = sal + 100 where empno=7369;update emp set ename='YC' where empno=7369;

4. ????

delete emp where empno=7369;drop table emp;

?????????

1. ????

create index person_index on emp(ename);

2. ????

create view view2 as select * from emp where deptno=20;

3.