要练好基本工,我不想工作的时候写个简单的查询语句再翻课本哟.
create table test(Name varchar2(16),Age number(3),Birth date)
select * from test
select * from emp
select ename,sal,sal*12 + 100 from emp
select ename ||' work at ' || job from emp
select ename||null||job from emp
select comm*10 from emp
select ename,sal*12 "年薪" from emp
select ename,' Today is '||Sysdate "日期" from emp
select * from emp
select distinct sal from emp
select distinct deptno from emp
select ename,job,deptno from emp where ename='KING'
select ename,sal,comm from emp where sal<=1500
select empno,ename,sal,mgr from emp where mgr in(7902,7698,7566)
select ename from emp where ename like '%A%'
select lower(ename) from emp where lower(ename) like '%a%'
select lower(ename) from emp
select * from test
desc test
insert into test(name,age,birth) values('suncheng_hong',
25,sysdate)
select * from test
delete test
insert into test(name,age,birth) values('suncheng_HONG',
25,sysdate)
SELECT * FROM TEST
select name from test where lower(name)='suncheng_hong'
select * from test where lower(name)='suncheng_hong'
select ename,sal,comm from emp where sal between 1100 and 1500
select * from emp where ename like '_A%'
select * from emp
select * from emp where ename is null
select * from emp where comm is null
select * from emp where sal>1000 and job='CLERK'
select * from emp where job not in ('CLERK','ANALYST')
SELECT * FROM emp where (job ='SALESMAN' OR JOB = 'PRESIDENT') AND SAL>1500
SELECT * FROM emp where job ='SALESMAN' OR JOB = 'PRESIDENT' AND SAL>1500
select * from emp order by deptno desc,sal asc
select sal*12 annsal from emp order by annsal
select replace('oracle Sal','aaa') test from dual
select * from test
就到这里吧,有点累了,没有什么技术成分,我还要是打一打,练熟一些,心里踏实.