鈥︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︾簿鍝佽祫鏂欐帹鑽愨�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�︹�?/p>
1
1.desc(
鎻忚堪锛?/p>
emp
鎻忚堪
emp
杩欏紶琛?/p>
2.desc
dept
閮ㄩ棬琛?/p>
3.desc
salgrade
钖按绛夌骇
4.select *from table_name
鏌ユ壘琛ㄤ腑鐨勫厓绱?/p>
5.dual
鏄郴缁熶腑鐨勪竴寮犲崟琛岀┖琛?/p>
6.select *from dual
7.select sysdate from dual
鍙栧嚭绯荤粺鏃堕棿
8.select ename,sal*12 "annul sal"(
鍙栫殑鍒悕锛?/p>
from emp;
鏌ユ壘鐢ㄦ埛濮撳悕鍜岀敤鎴?/p>
鐨勫勾钖?/p>
9.
浠讳綍鍚湁绌哄�肩殑鏁板琛ㄨ揪寮忕殑鍊奸兘鏄┖鍊?/p>
select ename,sal*12+comm from emp;
10.select ename||sal from emp
鍏朵腑鐨?/p>
||
鐩稿綋浜庡皢
sal
鍏ㄩ儴杞寲涓哄瓧绗︿覆
11.
琛ㄧず瀛楃涓茬殑鏂规硶
select ename ||'ajjf' from emp;
12.
濡傛灉鍏朵腑鏈変竴涓崟寮曞彿灏辩敤
2
涓崟寮曞彿鏉ヤ唬鏇夸粬
select ename||'sakj' 'lds'from emp;
13.select
distinct
deptno
from
emp
(
鍘婚櫎閮ㄩ棬瀛楁涓噸澶嶇殑閮ㄥ垎
,
鍏抽敭瀛?/p>
distinct)
14.select distinct deptno,job from emp;(
鍘婚櫎杩?/p>
2
涓瓧娈典腑閲嶅鐨勭粍鍚?/p>
)
15.select
*from
dept
where
deptno=10;
鍙栧嚭鏉′欢
(
鍙栧嚭閮ㄩ棬缂栧彿涓?/p>
10
鐨?/p>
璁板綍
)
16.select * from emp where ename='CLIRK';
鍙栧嚭閮ㄩ棬涓鍚嶄负
clirk
鐨勮褰?/p>
(
娉?/p>
鎰忓彇鍑鸿繃绋嬩腑
ename
鐢ㄥ崟寮曞彿闅斿紑
)
17.select ename,sal from emp where sal>1500;
鍙栧嚭閮ㄩ棬涓柂姘村ぇ浜?/p>
1500
鐨勪汉
鐨勫鍚?/p>