oracle 简单sql语言
set pagesize 2;
select * from emp;
password xiaoming;
drop user 用户名 cascade(级联删)、
grant connect to xiaoming;
grant select on emp to xiaoming;
select * from scott.emp;
grant update on emp to xiaoming;
revoke 收回权限
revoke select on emp from xiaoming;
grant select on emp to xiaoming with grant option ;
grant select on scott.emp to xiaoming;
grant connectt to xiaoming with admin option;
create profile lock_accout limit failed_logi_attempts 3 password_lock_time 2;
alter user tea profile myprofile
char 定长 查询速度极快
varchar 变长
clob 大项
create table users (userName char(200),)
drop table users;
create table student(
2 xh number(
update student set sal =sal/2 where sex='男';
delete from student;
drop table student;
set point aa;
rollback to aa;
select distinct deptno,job from
select sal*13+nvl(comm,0)*13 "年工资",ename,comm from emp;
select ename,sal from emp where sal>3000
select ename,hirdate from emp where hiredate>'1-1月-1982';
select ename,sal from emp where sal>=2000 and sal<=2500;
select ename,sal from emp where ename like 'S%';
select enmae,sql from emp where enmae like '__o%'
select * from emp where (sal>500 or job='MANAGER') and enmae like 'a%'
select * from emp order by sal;
默认(asc):升序 desc :降序
select * from emp order by deptno ,sal desc
select * from emp order by deptno asc , hiredata desc;
select * from where sal> (select avg(sal) from emp);
评论