鎰熶簬鎬绘湁浜涚綉鍙嬫彁鍑轰竴浜涢潪甯稿熀纭�鐨勯棶棰橈紝姣斿鏈夋病鏈夊疄鐜版煇鏌愬姛鑳界殑鍑芥暟鍟婏紝
鏌愭煇鍑芥暟鏄仛浠�涔堢敤鐨勫晩锛屾牸寮忔槸浠�涔堢瓑绛夛紝鍚屾椂涔熸劅鍙楀埌鑷繁瀵?/p>
oracle
鍑芥暟
璁よ瘑鐨勪笉瓒筹紝浜庢槸闆嗕腑鏈堜綑鏃堕棿涓撴敞浜?/p>
oracle
鍑芥暟锛屽皬鏈夊績寰椾笉鏁㈢钘忥紝鍙戜箣
涓庤鍏叡浜�?/p>
鏈枃骞朵笉鍑嗗浠嬬粛鍏ㄩ儴鐨?/p>
oracle
鍑芥暟锛屽綋鍓嶆儏鍔夸笅锛屼亢涔熻繕娌¤繖涓椂闂达紝闇�
瑕佸涔犵殑涓滆タ澶浜嗭紝瑕佹妸澶氭暟鏃堕棿鑺卞湪瀛︿範缁忓父鑳界敤涓婄殑鎶�鏈柟闈?/p>
:)
锛屾墍浠ュ
鏋滄槸鍑嗗娣卞叆浜嗚В鎵�鏈?/p>
oracle
鍑芥暟鐨勬湅鍙嬶紝杩樻槸鍘诲叧娉細
Oracle SQL Reference
瀹樻柟鏂囨。鏇撮潬璋变竴浜涖�?/p>
鏈枃鏇村灏嗕細浠嬬粛涓夋�濆湪鏃ュ父涓粡甯镐細鐢ㄥ埌鐨勶紝
鎴栬�呰櫧鐒跺緢灏戠敤鍒帮紝
浣嗘槸鎰?/p>
瑙夋尯鏈夋剰鎬濈殑涓�浜涘嚱鏁般�傚垎浜岀被浠嬬粛锛屽垎鍒槸锛?/p>
钁楀悕鍑芥暟绡?/p>
锛嶇粡甯哥敤鍒扮殑鍑芥暟
闈炶憲鍚嶅嚱鏁扮瘒锛嶅嵆铏界劧寰堝皯鐢ㄥ埌锛屼絾鏌愪簺鎯呭喌涓嬪嵈寰堝疄鐢?/p>
娉細
N
琛ㄧず鏁板瓧鍨嬶紝
C
琛ㄧず瀛楃鍨嬶紝
D
琛ㄧず鏃ユ湡鍨嬶紝
[]
琛ㄧず鍐呬腑鍙傛暟鍙蹇?/p>
鐣ワ紝
fmt
琛ㄧず鏍煎紡銆?/p>
鍗曞�煎嚱鏁板湪鏌ヨ涓繑鍥炲崟涓�硷紝鍙搴旂敤鍒?/p>
select
锛?/p>
where
瀛愬彞锛?/p>
start with
浠ュ強
connect by
瀛愬彞鍜?/p>
having
瀛愬彞銆?/p>
(
涓�
).
鏁板�煎瀷鍑芥暟
(Number Functions)
鏁板�煎瀷鍑芥暟杈撳叆鏁板瓧鍨嬪弬鏁板苟杩斿洖鏁板�煎瀷鐨勫�笺�傚鏁拌绫诲嚱鏁扮殑杩斿洖鍊兼敮鎸?/p>
38
浣嶅皬鏁扮偣锛岃濡傦細
COS, COSH, EXP, LN, LOG, SIN, SINH, SQRT, TAN, and
TANH
鏀寔
36
浣嶅皬鏁扮偣銆?/p>
ACOS, ASIN, ATAN, and ATAN2
鏀寔
30
浣嶅皬鏁扮偣銆?/p>
1
銆?/p>
MOD(n1,n2)
杩斿洖
n1
闄?/p>
n2
鐨勪綑鏁帮紝濡傛灉
n2=0
鍒欒繑鍥?/p>
n1
鐨勫�笺�?/p>
渚嬪锛?/p>
SELECT MOD(24,5) FROM DUAL;
2
銆?/p>
ROUND(n1[,n2])
杩斿洖鍥涜垗浜斿叆灏忔暟鐐瑰彸杈?/p>
n2
浣嶅悗
n1
鐨勫�硷紝
n2
缂虹渷鍊间负
0
锛?/p>
濡傛灉
n2
涓鸿礋鏁板氨鑸嶅叆鍒板皬鏁扮偣宸﹁竟鐩稿簲鐨勪綅涓?/p>
(
铏界劧
oracle documents
涓婃彁鍒?/p>
n2
鐨勫�煎繀椤讳负鏁存暟锛屼簨瀹炰笂鎵ц鏃舵澶勭殑鍒ゆ柇骞朵笉涓ヨ皑锛屽嵆浣?/p>
n2
涓洪潪鏁存暟锛屽畠
涔熶細鑷姩灏?/p>
n2
鍙栨暣鍚庡仛澶勭悊锛屼絾鏄垜鏂囨。涓叾瀹冩彁鍒板繀椤讳负鏁寸殑鍦版柟闇�瑕佺壒鍒?/p>
娉ㄦ剰锛屽鏋滀笉涓烘暣鎵ц鏃朵細鎶ラ敊鐨?/p>
)
銆?/p>
渚嬪锛?/p>
SELECT ROUND(23.56),ROUND(23.56,1),ROUND(23.56,-1) FROM DUAL;
3
銆?/p>
TRUNC(n1[,n2]
杩斿洖鎴熬鍒?/p>
n2
浣嶅皬鏁扮殑
n1
鐨勫�硷紝
n2
缂虹渷璁剧疆涓?/p>
0
锛屽綋
n2
涓虹己鐪佽缃椂浼氬皢
n1
鎴熬涓烘暣鏁帮紝濡傛灉
n2
涓鸿礋鍊硷紝灏辨埅灏惧湪灏忔暟鐐瑰乏杈圭浉搴?/p>
鐨勪綅涓娿�?/p>
渚嬪锛?/p>
SELECT TRUNC(23.56),TRUNC(23.56,1),TRUNC(23.56,-1) FROM DUAL;
(
浜?/p>
).
瀛楃鍨嬪嚱鏁拌繑鍥炲瓧绗﹀�?/p>
(Character Functions Returning Character Values)
璇ョ被鍑芥暟杩斿洖涓庤緭鍏ョ被鍨嬬浉鍚岀殑绫诲瀷銆?/p>
杩斿洖鐨?/p>
CHAR
绫诲瀷鍊奸暱搴︿笉瓒呰繃
2000
瀛楄妭锛?/p>
飦?/p>