Oracle入门

select * from A_hr.employee;

–2创建
CREATE TABLESPACE tp_orders datafile ‘D:\app\oradata\orcl\tp_orders’ size 10M AUTOEXTEND ON

–用户
create user A_oe IDENTIFIED BY bdqn DEFAULT TABLESPACE tp_orders temporary tablespace temp
–授权
grant connect TO A_oe --能连上数据库 不能对数据库进行操作
grant RESOURCE TO A_oe–能对数据库进行操作,创建表 对表操作
–分页

select * from (select * from Scott.emp order by sal DESC) A;

–解锁
alter user A_oe identified by bdqn

–创建表
purge recyclebin;–清空回收站中的所有表
create table employee(
empno number(4) primary key,
ename varchar2(10),
job varchar2(9),
mgr number(4),
hirredata date,
sal number(7,2),
comm number(7,2),
deptno number(2)
)
drop table employee
select * from A_oe.employee

insert into employee(empno,ename,job,mgr,hirredata,sal,comm,deptno)
values(‘2’,‘李鹏’,‘保安’,‘10’,to_date(‘2020/1/12’,‘yyyy-mm-dd’),‘1200’,‘200’,‘12’)
insert into employee(empno,ename,job,mgr,hirredata,sal,comm,deptno)
values(‘6’,‘李yue鹏’,‘保安’,‘10’,to_date(‘2020/1/12’,‘yyyy-mm-dd’),‘22000’,‘200’,‘12’)
insert into employee(empno,ename,job,mgr,hirredata,sal,comm,deptno)
values(‘7’,‘李q鹏’,‘保安’,‘10’,to_date(‘2020/1/12’,‘yyyy-mm-dd’),‘12000’,‘200’,‘12’)
insert into employee(empno,ename,job,mgr,hirredata,sal,comm,deptno)
values(‘8’,‘李r鹏’,‘保安’,‘10’,to_date(‘2020/1/12’,‘yyyy-mm-dd’),‘19000’,‘200’,‘12’)

select * from (select A.*,ROWNUM N FROM (SELECT * FROM employee e order by sal DESC) A WHERE ROWNUM<10) WHERE N>4
select rownum from employee

select rownum,s.* from (select rownum r,s.* from employee s where rownum <=10) s where r>5;