Oracle SQL 內置函數大全

和9519

<<Oracle SQL 內置函數大全>>幻灯片:http://www.cnblogs.com/Files/Dicky/Oracle_SQL_Function.rar
1http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL中的单记录函数
2http://www.cnblogs.com/Images/OutliningIndicators/None.gif1.ASCII
3http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回与指定的字符对应的十进制数;
4http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectascii('A')A,ascii('a')a,ascii('0')zero,ascii('')spacefromdual;
5http://www.cnblogs.com/Images/OutliningIndicators/None.gif
6http://www.cnblogs.com/Images/OutliningIndicators/None.gifAAZEROSPACE
7http://www.cnblogs.com/Images/OutliningIndicators/None.gif------------------------------------
8http://www.cnblogs.com/Images/OutliningIndicators/None.gif65974832
9http://www.cnblogs.com/Images/OutliningIndicators/None.gif
10http://www.cnblogs.com/Images/OutliningIndicators/None.gif
11http://www.cnblogs.com/Images/OutliningIndicators/None.gif2.CHR
12http://www.cnblogs.com/Images/OutliningIndicators/None.gif给出整数,返回对应的字符;
13http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectchr(54740)zhao,chr(65)chr65fromdual;
14http://www.cnblogs.com/Images/OutliningIndicators/None.gif
15http://www.cnblogs.com/Images/OutliningIndicators/None.gifZHC
16http://www.cnblogs.com/Images/OutliningIndicators/None.gif---
17http://www.cnblogs.com/Images/OutliningIndicators/None.gif赵A
18http://www.cnblogs.com/Images/OutliningIndicators/None.gif
19http://www.cnblogs.com/Images/OutliningIndicators/None.gif3.CONCAT
20http://www.cnblogs.com/Images/OutliningIndicators/None.gif连接两个字符串;
21http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectconcat('010-','88888888')||'转23'高乾竞电话fromdual;
22http://www.cnblogs.com/Images/OutliningIndicators/None.gif
23http://www.cnblogs.com/Images/OutliningIndicators/None.gif高乾竞电话
24http://www.cnblogs.com/Images/OutliningIndicators/None.gif----------------
25http://www.cnblogs.com/Images/OutliningIndicators/None.gif010-88888888转23
26http://www.cnblogs.com/Images/OutliningIndicators/None.gif
27http://www.cnblogs.com/Images/OutliningIndicators/None.gif4.INITCAP
28http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回字符串并将字符串的第一个字母变为大写;
29http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectinitcap('smith')uppfromdual;
30http://www.cnblogs.com/Images/OutliningIndicators/None.gif
31http://www.cnblogs.com/Images/OutliningIndicators/None.gifUPP
32http://www.cnblogs.com/Images/OutliningIndicators/None.gif-----
33http://www.cnblogs.com/Images/OutliningIndicators/None.gifSmith
34http://www.cnblogs.com/Images/OutliningIndicators/None.gif
35http://www.cnblogs.com/Images/OutliningIndicators/None.gif
36http://www.cnblogs.com/Images/OutliningIndicators/None.gif5.INSTR(C1,C2,I,J)
37http://www.cnblogs.com/Images/OutliningIndicators/None.gif在一个字符串中搜索指定的字符,返回发现指定的字符的位置;
38http://www.cnblogs.com/Images/OutliningIndicators/None.gifC1被搜索的字符串
39http://www.cnblogs.com/Images/OutliningIndicators/None.gifC2希望搜索的字符串
40http://www.cnblogs.com/Images/OutliningIndicators/None.gifI搜索的开始位置,默认为1
41http://www.cnblogs.com/Images/OutliningIndicators/None.gifJ出现的位置,默认为1
42http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectinstr('oracletraning','ra',1,2)instringfromdual;
43http://www.cnblogs.com/Images/OutliningIndicators/None.gif
44http://www.cnblogs.com/Images/OutliningIndicators/None.gifINSTRING
45http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------
46http://www.cnblogs.com/Images/OutliningIndicators/None.gif9
47http://www.cnblogs.com/Images/OutliningIndicators/None.gif
48http://www.cnblogs.com/Images/OutliningIndicators/None.gif
49http://www.cnblogs.com/Images/OutliningIndicators/None.gif6.LENGTH
50http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回字符串的长度;
51http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectname,length(name),addr,length(addr),sal,length(to_char(sal))fromgao.nchar_tst;
52http://www.cnblogs.com/Images/OutliningIndicators/None.gif
53http://www.cnblogs.com/Images/OutliningIndicators/None.gifNAMELENGTH(NAME)ADDRLENGTH(ADDR)SALLENGTH(TO_CHAR(SAL))
54http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------------------------------------------------------------------------
55http://www.cnblogs.com/Images/OutliningIndicators/None.gif高乾竞3北京市海锭区69999.997
56http://www.cnblogs.com/Images/OutliningIndicators/None.gif
57http://www.cnblogs.com/Images/OutliningIndicators/None.gif
58http://www.cnblogs.com/Images/OutliningIndicators/None.gif
59http://www.cnblogs.com/Images/OutliningIndicators/None.gif7.LOWER
60http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回字符串,并将所有的字符小写
61http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectlower('AaBbCcDd')AaBbCcDdfromdual;
62http://www.cnblogs.com/Images/OutliningIndicators/None.gif
63http://www.cnblogs.com/Images/OutliningIndicators/None.gifAABBCCDD
64http://www.cnblogs.com/Images/OutliningIndicators/None.gif--------
65http://www.cnblogs.com/Images/OutliningIndicators/None.gifaabbccdd
66http://www.cnblogs.com/Images/OutliningIndicators/None.gif
67http://www.cnblogs.com/Images/OutliningIndicators/None.gif
68http://www.cnblogs.com/Images/OutliningIndicators/None.gif8.UPPER
69http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回字符串,并将所有的字符大写
70http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectupper('AaBbCcDd')upperfromdual;
71http://www.cnblogs.com/Images/OutliningIndicators/None.gif
72http://www.cnblogs.com/Images/OutliningIndicators/None.gifUPPER
73http://www.cnblogs.com/Images/OutliningIndicators/None.gif--------
74http://www.cnblogs.com/Images/OutliningIndicators/None.gifAABBCCDD
75http://www.cnblogs.com/Images/OutliningIndicators/None.gif
76http://www.cnblogs.com/Images/OutliningIndicators/None.gif
77http://www.cnblogs.com/Images/OutliningIndicators/None.gif
78http://www.cnblogs.com/Images/OutliningIndicators/None.gif9.RPAD和LPAD(粘贴字符)
79http://www.cnblogs.com/Images/OutliningIndicators/None.gifRPAD在列的右边粘贴字符
80http://www.cnblogs.com/Images/OutliningIndicators/None.gifLPAD在列的左边粘贴字符
81http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectlpad(rpad('gao',10,'*'),17,'*')fromdual;
82http://www.cnblogs.com/Images/OutliningIndicators/None.gif
83http://www.cnblogs.com/Images/OutliningIndicators/None.gifLPAD(RPAD('GAO',1
84http://www.cnblogs.com/Images/OutliningIndicators/None.gif-----------------
85http://www.cnblogs.com/Images/OutliningIndicators/None.gif*******gao*******
86http://www.cnblogs.com/Images/OutliningIndicators/None.gif不够字符则用*来填满
87http://www.cnblogs.com/Images/OutliningIndicators/None.gif
88http://www.cnblogs.com/Images/OutliningIndicators/None.gif
89http://www.cnblogs.com/Images/OutliningIndicators/None.gif10.LTRIM和RTRIM
90http://www.cnblogs.com/Images/OutliningIndicators/None.gifLTRIM删除左边出现的字符串
91http://www.cnblogs.com/Images/OutliningIndicators/None.gifRTRIM删除右边出现的字符串
92http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectltrim(rtrim('gaoqianjing',''),'')fromdual;
93http://www.cnblogs.com/Images/OutliningIndicators/None.gif
94http://www.cnblogs.com/Images/OutliningIndicators/None.gifLTRIM(RTRIM('
95http://www.cnblogs.com/Images/OutliningIndicators/None.gif-------------
96http://www.cnblogs.com/Images/OutliningIndicators/None.gifgaoqianjing
97http://www.cnblogs.com/Images/OutliningIndicators/None.gif
98http://www.cnblogs.com/Images/OutliningIndicators/None.gif
99http://www.cnblogs.com/Images/OutliningIndicators/None.gif11.SUBSTR(string,start,count)
100http://www.cnblogs.com/Images/OutliningIndicators/None.gif取子字符串,从start开始,取count个
101http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectsubstr('13088888888',3,8)fromdual;
102http://www.cnblogs.com/Images/OutliningIndicators/None.gif
103http://www.cnblogs.com/Images/OutliningIndicators/None.gifSUBSTR('
104http://www.cnblogs.com/Images/OutliningIndicators/None.gif--------
105http://www.cnblogs.com/Images/OutliningIndicators/None.gif08888888
106http://www.cnblogs.com/Images/OutliningIndicators/None.gif
107http://www.cnblogs.com/Images/OutliningIndicators/None.gif
108http://www.cnblogs.com/Images/OutliningIndicators/None.gif12.REPLACE('string','s1','s2')
109http://www.cnblogs.com/Images/OutliningIndicators/None.gifstring希望被替换的字符或变量
110http://www.cnblogs.com/Images/OutliningIndicators/None.gifs1被替换的字符串
111http://www.cnblogs.com/Images/OutliningIndicators/None.gifs2要替换的字符串
112http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectreplace('heloveyou','he','i')fromdual;
113http://www.cnblogs.com/Images/OutliningIndicators/None.gif
114http://www.cnblogs.com/Images/OutliningIndicators/None.gifREPLACE('H
115http://www.cnblogs.com/Images/OutliningIndicators/None.gif----------
116http://www.cnblogs.com/Images/OutliningIndicators/None.gifiloveyou
117http://www.cnblogs.com/Images/OutliningIndicators/None.gif
118http://www.cnblogs.com/Images/OutliningIndicators/None.gif
119http://www.cnblogs.com/Images/OutliningIndicators/None.gif13.SOUNDEX
120http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个与给定的字符串读音相同的字符串
121http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>createtabletable1(xmvarchar(8));
122http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>insertintotable1values('weather');
123http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>insertintotable1values('wether');
124http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>insertintotable1values('gao');
125http://www.cnblogs.com/Images/OutliningIndicators/None.gif
126http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectxmfromtable1wheresoundex(xm)=soundex('weather');
127http://www.cnblogs.com/Images/OutliningIndicators/None.gif
128http://www.cnblogs.com/Images/OutliningIndicators/None.gifXM
129http://www.cnblogs.com/Images/OutliningIndicators/None.gif--------
130http://www.cnblogs.com/Images/OutliningIndicators/None.gifweather
131http://www.cnblogs.com/Images/OutliningIndicators/None.gifwether
132http://www.cnblogs.com/Images/OutliningIndicators/None.gif
133http://www.cnblogs.com/Images/OutliningIndicators/None.gif
134http://www.cnblogs.com/Images/OutliningIndicators/None.gif14.TRIM('s'from'string')
135http://www.cnblogs.com/Images/OutliningIndicators/None.gifLEADING剪掉前面的字符
136http://www.cnblogs.com/Images/OutliningIndicators/None.gifTRAILING剪掉后面的字符
137http://www.cnblogs.com/Images/OutliningIndicators/None.gif如果不指定,默认为空格符
138http://www.cnblogs.com/Images/OutliningIndicators/None.gif
139http://www.cnblogs.com/Images/OutliningIndicators/None.gif15.ABS
140http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回指定值的绝对值
141http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectabs(100),abs(-100)fromdual;
142http://www.cnblogs.com/Images/OutliningIndicators/None.gif
143http://www.cnblogs.com/Images/OutliningIndicators/None.gifABS(100)ABS(-100)
144http://www.cnblogs.com/Images/OutliningIndicators/None.gif------------------
145http://www.cnblogs.com/Images/OutliningIndicators/None.gif100100
146http://www.cnblogs.com/Images/OutliningIndicators/None.gif
147http://www.cnblogs.com/Images/OutliningIndicators/None.gif
148http://www.cnblogs.com/Images/OutliningIndicators/None.gif16.ACOS
149http://www.cnblogs.com/Images/OutliningIndicators/None.gif给出反余弦的值
150http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectacos(-1)fromdual;
151http://www.cnblogs.com/Images/OutliningIndicators/None.gif
152http://www.cnblogs.com/Images/OutliningIndicators/None.gifACOS(-1)
153http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------
154http://www.cnblogs.com/Images/OutliningIndicators/None.gif3.1415927
155http://www.cnblogs.com/Images/OutliningIndicators/None.gif
156http://www.cnblogs.com/Images/OutliningIndicators/None.gif
157http://www.cnblogs.com/Images/OutliningIndicators/None.gif17.ASIN
158http://www.cnblogs.com/Images/OutliningIndicators/None.gif给出反正弦的值
159http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectasin(0.5)fromdual;
160http://www.cnblogs.com/Images/OutliningIndicators/None.gif
161http://www.cnblogs.com/Images/OutliningIndicators/None.gifASIN(0.5)
162http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------
163http://www.cnblogs.com/Images/OutliningIndicators/None.gif.52359878
164http://www.cnblogs.com/Images/OutliningIndicators/None.gif
165http://www.cnblogs.com/Images/OutliningIndicators/None.gif
166http://www.cnblogs.com/Images/OutliningIndicators/None.gif18.ATAN
167http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个数字的反正切值
168http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectatan(1)fromdual;
169http://www.cnblogs.com/Images/OutliningIndicators/None.gif
170http://www.cnblogs.com/Images/OutliningIndicators/None.gifATAN(1)
171http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------
172http://www.cnblogs.com/Images/OutliningIndicators/None.gif.78539816
173http://www.cnblogs.com/Images/OutliningIndicators/None.gif
174http://www.cnblogs.com/Images/OutliningIndicators/None.gif
175http://www.cnblogs.com/Images/OutliningIndicators/None.gif19.CEIL
176http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回大于或等于给出数字的最小整数
177http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectceil(3.1415927)fromdual;
178http://www.cnblogs.com/Images/OutliningIndicators/None.gif
179http://www.cnblogs.com/Images/OutliningIndicators/None.gifCEIL(3.1415927)
180http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------------
181http://www.cnblogs.com/Images/OutliningIndicators/None.gif4
182http://www.cnblogs.com/Images/OutliningIndicators/None.gif
183http://www.cnblogs.com/Images/OutliningIndicators/None.gif
184http://www.cnblogs.com/Images/OutliningIndicators/None.gif20.COS
185http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个给定数字的余弦
186http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectcos(-3.1415927)fromdual;
187http://www.cnblogs.com/Images/OutliningIndicators/None.gif
188http://www.cnblogs.com/Images/OutliningIndicators/None.gifCOS(-3.1415927)
189http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------------
190http://www.cnblogs.com/Images/OutliningIndicators/None.gif-1
191http://www.cnblogs.com/Images/OutliningIndicators/None.gif
192http://www.cnblogs.com/Images/OutliningIndicators/None.gif
193http://www.cnblogs.com/Images/OutliningIndicators/None.gif21.COSH
194http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个数字反余弦值
195http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectcosh(20)fromdual;
196http://www.cnblogs.com/Images/OutliningIndicators/None.gif
197http://www.cnblogs.com/Images/OutliningIndicators/None.gifCOSH(20)
198http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------
199http://www.cnblogs.com/Images/OutliningIndicators/None.gif242582598
200http://www.cnblogs.com/Images/OutliningIndicators/None.gif
201http://www.cnblogs.com/Images/OutliningIndicators/None.gif
202http://www.cnblogs.com/Images/OutliningIndicators/None.gif22.EXP
203http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个数字e的n次方根
204http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectexp(2),exp(1)fromdual;
205http://www.cnblogs.com/Images/OutliningIndicators/None.gif
206http://www.cnblogs.com/Images/OutliningIndicators/None.gifEXP(2)EXP(1)
207http://www.cnblogs.com/Images/OutliningIndicators/None.gif------------------
208http://www.cnblogs.com/Images/OutliningIndicators/None.gif7.38905612.7182818
209http://www.cnblogs.com/Images/OutliningIndicators/None.gif
210http://www.cnblogs.com/Images/OutliningIndicators/None.gif
211http://www.cnblogs.com/Images/OutliningIndicators/None.gif23.FLOOR
212http://www.cnblogs.com/Images/OutliningIndicators/None.gif对给定的数字取整数
213http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectfloor(2345.67)fromdual;
214http://www.cnblogs.com/Images/OutliningIndicators/None.gif
215http://www.cnblogs.com/Images/OutliningIndicators/None.gifFLOOR(2345.67)
216http://www.cnblogs.com/Images/OutliningIndicators/None.gif--------------
217http://www.cnblogs.com/Images/OutliningIndicators/None.gif2345
218http://www.cnblogs.com/Images/OutliningIndicators/None.gif
219http://www.cnblogs.com/Images/OutliningIndicators/None.gif
220http://www.cnblogs.com/Images/OutliningIndicators/None.gif24.LN
221http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个数字的对数值
222http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectln(1),ln(2),ln(2.7182818)fromdual;
223http://www.cnblogs.com/Images/OutliningIndicators/None.gif
224http://www.cnblogs.com/Images/OutliningIndicators/None.gifLN(1)LN(2)LN(2.7182818)
225http://www.cnblogs.com/Images/OutliningIndicators/None.gif-------------------------------
226http://www.cnblogs.com/Images/OutliningIndicators/None.gif0.69314718.99999999
227http://www.cnblogs.com/Images/OutliningIndicators/None.gif
228http://www.cnblogs.com/Images/OutliningIndicators/None.gif
229http://www.cnblogs.com/Images/OutliningIndicators/None.gif25.LOG(n1,n2)
230http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个以n1为底n2的对数
231http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectlog(2,1),log(2,4)fromdual;
232http://www.cnblogs.com/Images/OutliningIndicators/None.gif
233http://www.cnblogs.com/Images/OutliningIndicators/None.gifLOG(2,1)LOG(2,4)
234http://www.cnblogs.com/Images/OutliningIndicators/None.gif------------------
235http://www.cnblogs.com/Images/OutliningIndicators/None.gif02
236http://www.cnblogs.com/Images/OutliningIndicators/None.gif
237http://www.cnblogs.com/Images/OutliningIndicators/None.gif
238http://www.cnblogs.com/Images/OutliningIndicators/None.gif26.MOD(n1,n2)
239http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个n1除以n2的余数
240http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectmod(10,3),mod(3,3),mod(2,3)fromdual;
241http://www.cnblogs.com/Images/OutliningIndicators/None.gif
242http://www.cnblogs.com/Images/OutliningIndicators/None.gifMOD(10,3)MOD(3,3)MOD(2,3)
243http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------------------------
244http://www.cnblogs.com/Images/OutliningIndicators/None.gif102
245http://www.cnblogs.com/Images/OutliningIndicators/None.gif
246http://www.cnblogs.com/Images/OutliningIndicators/None.gif
247http://www.cnblogs.com/Images/OutliningIndicators/None.gif27.POWER
248http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回n1的n2次方根
249http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectpower(2,10),power(3,3)fromdual;
250http://www.cnblogs.com/Images/OutliningIndicators/None.gif
251http://www.cnblogs.com/Images/OutliningIndicators/None.gifPOWER(2,10)POWER(3,3)
252http://www.cnblogs.com/Images/OutliningIndicators/None.gif---------------------
253http://www.cnblogs.com/Images/OutliningIndicators/None.gif102427
254http://www.cnblogs.com/Images/OutliningIndicators/None.gif
255http://www.cnblogs.com/Images/OutliningIndicators/None.gif
256http://www.cnblogs.com/Images/OutliningIndicators/None.gif28.ROUND和TRUNC
257http://www.cnblogs.com/Images/OutliningIndicators/None.gif按照指定的精度进行舍入
258http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectround(55.5),round(-55.4),trunc(55.5),trunc(-55.5)fromdual;
259http://www.cnblogs.com/Images/OutliningIndicators/None.gif
260http://www.cnblogs.com/Images/OutliningIndicators/None.gifROUND(55.5)ROUND(-55.4)TRUNC(55.5)TRUNC(-55.5)
261http://www.cnblogs.com/Images/OutliningIndicators/None.gif----------------------------------------------
262http://www.cnblogs.com/Images/OutliningIndicators/None.gif56-5555-55
263http://www.cnblogs.com/Images/OutliningIndicators/None.gif
264http://www.cnblogs.com/Images/OutliningIndicators/None.gif
265http://www.cnblogs.com/Images/OutliningIndicators/None.gif29.SIGN
266http://www.cnblogs.com/Images/OutliningIndicators/None.gif取数字n的符号,大于0返回1,小于0返回-1,等于0返回0
267http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectsign(123),sign(-100),sign(0)fromdual;
268http://www.cnblogs.com/Images/OutliningIndicators/None.gif
269http://www.cnblogs.com/Images/OutliningIndicators/None.gifSIGN(123)SIGN(-100)SIGN(0)
270http://www.cnblogs.com/Images/OutliningIndicators/None.gif----------------------------
271http://www.cnblogs.com/Images/OutliningIndicators/None.gif1-10
272http://www.cnblogs.com/Images/OutliningIndicators/None.gif
273http://www.cnblogs.com/Images/OutliningIndicators/None.gif
274http://www.cnblogs.com/Images/OutliningIndicators/None.gif30.SIN
275http://www.cnblogs.com/Images/OutliningIndicators/None.gif返回一个数字的正弦值
276http://www.cnblogs.com/Images/OutliningIndicators/None.gifSQL>selectsin(1.57079)fromdual;
277http://www.cnblogs.com/Images/OutliningIndicators/None.gif
278http://www.cnblogs.com/Images/OutliningIndicators/None.gifSIN(1.57079)
279color