Posted on 2010-06-30 00:45
斷點 閱讀(222)
評論(0) 編輯 收藏 所屬分類:
Oracle DBA
sqlplus sys/sys as sysdba;
alert user scott account unlock;
desc emp;
select ename,sal*12 from emp;
select sysdate from dual; --dual為空表
select ename,sal*12 annual_sal from emp; --別名
--數值+null 為null
select ename||sal from emp; --拼串
select ename||'aaa''bbb' from emp; --含'的拼串,''替換為'
select distinct deptno,job from emp; --去掉2個字段值的組合
select * from emp where deptno=10 and ename='CLARK';
select ename,sal from emp where sal>1500;
select ename,sal from emp where deptno<>10;
select ename,sal from emp where sal between 800 and 1500; -- sal>=800 and sal<=1500
select ename,sal,comm from emp where comm is null; --is not null
select ename,sal,comm from emp where sal in (800,1500); -- not in (800,1500)
select ename from emp where ename like '_A%' -- %為0個或多個，-為1個
select ename from emp where ename like '%\%%' -- 名字含有%，需要\為轉義字符處理
select ename from emp where ename like '%$%%' escape '$' -- 可以使用$作為轉義字符
select ename,sal,deptno from emp order by deptno asc,ename desc; -- 升序asc，降序 desc