涓�銆?/p>
鍒ゆ柇棰橈紝姝ｇ‘璇峰啓鍐?/p>
"T"
锛岄敊璇鍐欏啓
"F"
锛?/p>
1
銆?/p>
oracle
鏁版嵁搴撶郴缁熶腑锛屽惎鍔ㄦ暟鎹簱鐨勭涓�姝ユ槸鍚姩涓�涓暟鎹簱瀹炰緥銆?/p>
锛?/p>
T
锛?/p>
2
銆?/p>
Oracle
鏈嶅姟鍣ㄧ鐨勭洃鍚▼搴忔槸椹荤暀鍦ㄦ湇鍔″櫒涓婄殑鍗曠嫭杩涚▼锛?/p>
涓撻棬璐熻矗鍝嶅簲瀹㈡埛鏈虹殑杩炴帴璇?/p>
姹傘�?/p>
锛?/p>
F
锛?/p>
3
銆?/p>
oracle
鏁版嵁搴撲腑瀹炰緥鍜屾暟鎹簱鏄竴涓�瀵瑰簲鐨勶紙闈?/p>
ORACLE
骞惰鏈嶅姟锛岄潪闆嗙兢锛?/p>
銆?/p>
锛?/p>
T
锛?/p>
4
銆佺郴缁熷叏灞�鍖?/p>
SGA
鏄拡瀵规煇涓�鏈嶅姟鍣ㄨ繘绋嬭�屼繚鐣欑殑鍐呭瓨鍖哄煙锛屽畠鏄笉鍙互鍏变韩鐨勩�?/p>
锛?/p>
F
锛?/p>
5
銆佹暟鎹簱瀛楀吀瑙嗗浘
ALL_***
瑙嗗浘鍙寘鍚綋鍓嶇敤鎴锋嫢鏈夌殑鏁版嵁搴撳璞′俊鎭�?/p>
锛?/p>
F
锛?/p>
8
銆佹暟鎹瓧鍏镐腑鐨勫唴瀹归兘琚繚瀛樺湪
SYSTEM
琛ㄧ┖闂翠腑銆?/p>
锛?/p>
T
锛?/p>
9
銆?/p>
HAVING
鍚庨潰鐨勬潯浠朵腑鍙互鏈夎仛闆嗗嚱鏁帮紝姣斿
SUM(),AVG()
绛夛紝
WHERE
鍚庨潰鐨?/p>
鏉′欢涓篃鍙互鏈夎仛闆嗗嚱鏁般�?/p>
锛?/p>
F
锛?/p>
10
銆?/p>
"
涓婃捣瑗垮寳浜?/p>
"
鍙互閫氳繃
like
鈥?/p>
%
涓婃捣
_
鈥欐煡鍑烘潵銆?/p>
锛?/p>
F
锛?/p>
11
銆?/p>
琛ㄧ┖闂存槸
oracle
鏈�澶х殑閫昏緫缁勬垚閮ㄥ垎銆?/p>
Oracle
鏁版嵁搴撶敱涓�涓垨澶氫釜琛ㄧ┖闂寸粍鎴愩�?/p>
涓�涓〃绌洪棿鐢变竴涓垨澶氫釜鏁版嵁鏂囦欢缁勬垚锛屼絾涓�涓暟鎹枃浠跺彧鑳藉睘浜庝竴涓〃绌洪棿銆?/p>
锛?/p>
T
锛?/p>
12
銆佽〃绌洪棿鍒嗕负姘镐箙琛ㄧ┖闂村拰涓存椂琛ㄧ┖闂翠袱绉嶇被鍨嬨�?/p>
锛?/p>
T
锛?/p>