涓�銆?/p>
鍒ゆ柇棰橈紝姝ｇ‘璇峰啓鍐?/p>
"T"
锛岄敊璇鍐欏啓
"F"
锛?/p>
1
銆?/p>
oracle
鏁版嵁搴撶郴缁熶腑锛?/p>
鍚姩鏁版嵁搴撶殑绗竴姝ユ槸鍚姩涓�涓暟鎹簱瀹炰緥銆?/p>
锛?/p>
T
锛?/p>
2
銆?/p>
Oracle
鏈嶅姟鍣ㄧ鐨勭洃鍚▼搴忔槸椹荤暀鍦ㄦ湇鍔″櫒涓婄殑鍗曠嫭杩涚▼锛屼笓闂ㄨ礋璐ｅ搷搴斿
鎴锋満鐨勮繛鎺ヨ姹傘�傦紙
F
锛?/p>
3
銆?/p>
oracle
鏁版嵁搴撲腑瀹炰緥鍜屾暟鎹簱鏄竴涓�瀵瑰簲鐨?/p>
锛堥潪
ORACLE
骞惰鏈嶅姟锛?/p>
闈為泦缇わ級
銆?/p>
锛?/p>
T
锛?/p>
4
銆佺郴缁熷叏灞�鍖?/p>
SGA
鏄拡瀵规煇涓�鏈嶅姟鍣ㄨ繘绋嬭�屼繚鐣欑殑鍐呭瓨鍖哄煙锛屽畠鏄笉鍙互鍏变韩
鐨勩�傦紙
F
锛?/p>
5
銆佹暟鎹簱瀛楀吀瑙嗗浘
ALL_***
瑙嗗浘鍙寘鍚綋鍓嶇敤鎴锋嫢鏈夌殑鏁版嵁搴撳璞′俊鎭�?/p>
锛?/p>
F
锛?/p>
8
銆佹暟鎹瓧鍏镐腑鐨勫唴瀹归兘琚繚瀛樺湪
SYSTEM
琛ㄧ┖闂翠腑銆傦紙
T
锛?/p>
9
銆?/p>
HAVING
鍚庨潰鐨勬潯浠朵腑鍙互鏈夎仛闆嗗嚱鏁帮紝
姣斿
SUM(),AVG()
绛夛紝
WHERE
鍚庨潰鐨?/p>
鏉′欢涓篃鍙互鏈夎仛闆嗗嚱鏁般�傦紙
F
锛?/p>
10
銆?/p>
"
涓婃捣瑗垮寳浜?/p>
"
鍙互閫氳繃
like
鈥?/p>
%
涓婃捣
_
鈥欐煡鍑烘潵銆傦紙
F
锛?/p>
11
銆?/p>
琛ㄧ┖闂存槸
oracle
鏈�澶х殑閫昏緫缁勬垚閮ㄥ垎銆?/p>
Oracle
鏁版嵁搴撶敱涓�涓垨澶氫釜琛ㄧ┖闂?/p>
缁勬垚銆?/p>
涓�涓〃绌洪棿鐢变竴涓垨澶氫釜鏁版嵁鏂囦欢缁勬垚锛?/p>
浣嗕竴涓暟鎹枃浠跺彧鑳藉睘浜庝竴涓〃
绌洪棿銆傦紙
T
锛?/p>
12
銆佽〃绌洪棿鍒嗕负姘镐箙琛ㄧ┖闂村拰涓存椂琛ㄧ┖闂翠袱绉嶇被鍨嬨�傦紙
T
锛?/p>
13
銆?/p>
truncate
鏄?/p>
DDL
鎿嶄綔锛屼笉鑳?/p>
rollback
銆傦紙
T
锛?/p>
14
銆?/p>
濡傛灉闇�瑕佸悜琛ㄤ腑鎻掑叆涓�鎵瑰凡缁忓瓨鍦ㄧ殑鏁版嵁锛?/p>
鍙互鍦?/p>
INSERT
璇彞涓娇鐢?/p>
WHERE
璇彞銆傦紙
F
锛?/p>
15
銆?/p>
Oracle
鏁版嵁搴撲腑瀛楃涓插拰鏃ユ湡蹇呴』浣跨敤鍙屽紩鍙锋爣璇嗐�傦紙
F
锛?/p>
16
銆?/p>
Oracle
鏁版嵁搴撲腑瀛楃涓叉暟鎹槸鍖哄垎澶у皬鍐欑殑銆傦紙
T
锛?/p>
17
銆?/p>
Oracle
鏁版嵁搴撲腑鍙互瀵圭害鏉熻繘琛岀鐢紝绂佺敤绾︽潫鍙互鍦ㄦ墽琛屼竴浜涚壒娈婃搷浣?/p>
鏃跺�欎繚璇佹搷浣滆兘姝ｅ父杩涜銆傦紙
F
锛?/p>
18
銆佷负浜嗚妭鐪佸瓨鍌ㄧ┖闂达紝瀹氫箟琛ㄦ椂搴旇灏嗗彲鑳藉寘鍚?/p>
NULL
鍊肩殑瀛楁鏀惧湪瀛楁鍒楄〃
鐨勬湯灏俱�傦紙
T
锛?/p>
20
銆佸湪杩炴帴鎿嶄綔涓紝濡傛灉宸﹁〃鍜屽彸琛ㄤ腑涓嶆弧瓒宠繛鎺ユ潯浠剁殑鏁版嵁閮藉嚭鐜板湪缁撴灉涓紝
閭ｄ箞杩欑杩炴帴鏄叏澶栬繛鎺ャ�傦紙
T
锛?/p>
21
銆?/p>
鑷劧杩炴帴鏄牴鎹袱涓〃涓悓鍚嶇殑鍒楄�岃繘琛岃繛鎺ョ殑锛?/p>
褰撳垪涓嶅悓鍚嶆椂锛?/p>
鑷劧杩炴帴
灏嗗け鍘绘剰涔夈�傦紙
T
锛?/p>
23
銆?/p>
PL/SQL
浠ｇ爜鍧楀０鏄庡尯鍙湁鍙棤銆傦紙
T
锛?/p>
24
銆?/p>
闅愬紡娓告爣涓庢樉寮忔父鏍囩殑涓嶅悓鍦ㄤ簬鏄惧紡娓告爣浠呬粎璁块棶涓�琛岋紝
闅愬紡鐨勫彲浠ヨ闂
琛屻�傦紙
F
锛?/p>