📄 oracle_function_guinness.mht
字号:
=
<P>13.SOUNDEX<BR>=B7=B5=BB=D8=D2=BB=B8=F6=D3=EB=B8=F8=B6=A8=B5=C4=D7=D6=B7=
=FB=B4=AE=B6=C1=D2=F4=CF=E0=CD=AC=B5=C4=D7=D6=B7=FB=B4=AE<BR>SQL> =
create table table1(xm=20
varchar(8));<BR>SQL> insert into table1 =
values('weather');<BR>SQL>=20
insert into table1 values('wether');<BR>SQL> insert into table1 =
values('gao');</P>
<P>SQL> select xm from table1 where =
soundex(xm)=3Dsoundex('weather');</P>
<P>XM<BR>--------<BR>weather<BR>wether<BR></P>
<P>14.TRIM('s' from 'string')<BR>LEADING =
=BC=F4=B5=F4=C7=B0=C3=E6=B5=C4=D7=D6=B7=FB<BR>TRAILING=20
=
=BC=F4=B5=F4=BA=F3=C3=E6=B5=C4=D7=D6=B7=FB<BR>=C8=E7=B9=FB=B2=BB=D6=B8=B6=
=A8,=C4=AC=C8=CF=CE=AA=BF=D5=B8=F1=B7=FB </P>
=
<P>15.ABS<BR>=B7=B5=BB=D8=D6=B8=B6=A8=D6=B5=B5=C4=BE=F8=B6=D4=D6=B5<BR>SQ=
L> select abs(100),abs(-100) from dual;</P>
<P>ABS(100) ABS(-100)<BR>--------- ---------<BR>100 100<BR></P>
=
<P>16.ACOS<BR>=B8=F8=B3=F6=B7=B4=D3=E0=CF=D2=B5=C4=D6=B5<BR>SQL> =
select acos(-1) from dual;</P>
<P>ACOS(-1)<BR>---------<BR>3.1415927<BR></P>
=
<P>17.ASIN<BR>=B8=F8=B3=F6=B7=B4=D5=FD=CF=D2=B5=C4=D6=B5<BR>SQL> =
select asin(0.5) from dual;</P>
<P>ASIN(0.5)<BR>---------<BR>.52359878<BR></P>
=
<P>18.ATAN<BR>=B7=B5=BB=D8=D2=BB=B8=F6=CA=FD=D7=D6=B5=C4=B7=B4=D5=FD=C7=D0=
=D6=B5<BR>SQL> select atan(1) from dual;</P>
<P>ATAN(1)<BR>---------<BR>.78539816<BR></P>
=
<P>19.CEIL<BR>=B7=B5=BB=D8=B4=F3=D3=DA=BB=F2=B5=C8=D3=DA=B8=F8=B3=F6=CA=FD=
=D7=D6=B5=C4=D7=EE=D0=A1=D5=FB=CA=FD<BR>SQL> select ceil(3.1415927) =
from=20
dual;</P>
<P>CEIL(3.1415927)<BR>---------------<BR>4<BR></P>
=
<P>20.COS<BR>=B7=B5=BB=D8=D2=BB=B8=F6=B8=F8=B6=A8=CA=FD=D7=D6=B5=C4=D3=E0=
=CF=D2<BR>SQL> select cos(-3.1415927) from dual;</P>
<P>COS(-3.1415927)<BR>---------------<BR>-1<BR></P>
=
<P>21.COSH<BR>=B7=B5=BB=D8=D2=BB=B8=F6=CA=FD=D7=D6=B7=B4=D3=E0=CF=D2=D6=B5=
<BR>SQL> select cosh(20) from dual;</P>
<P>COSH(20)<BR>---------<BR>242582598<BR></P>
=
<P>22.EXP<BR>=B7=B5=BB=D8=D2=BB=B8=F6=CA=FD=D7=D6e=B5=C4n=B4=CE=B7=BD=B8=F9=
<BR>SQL> select exp(2),exp(1) from dual;</P>
<P>EXP(2) EXP(1)<BR>--------- ---------<BR>7.3890561 =
2.7182818<BR></P>
=
<P>23.FLOOR<BR>=B6=D4=B8=F8=B6=A8=B5=C4=CA=FD=D7=D6=C8=A1=D5=FB=CA=FD<BR>=
SQL> select floor(2345.67) from dual;</P>
<P>FLOOR(2345.67)<BR>--------------<BR>2345<BR></P>
=
<P>24.LN<BR>=B7=B5=BB=D8=D2=BB=B8=F6=CA=FD=D7=D6=B5=C4=B6=D4=CA=FD=D6=B5<=
BR>SQL> select ln(1),ln(2),ln(2.7182818) from=20
dual;</P>
<P>LN(1) LN(2) LN(2.7182818)<BR>--------- --------- =
-------------<BR>0=20
.69314718 .99999999<BR></P>
=
<P>25.LOG(n1,n2)<BR>=B7=B5=BB=D8=D2=BB=B8=F6=D2=D4n1=CE=AA=B5=D7n2=B5=C4=B6=
=D4=CA=FD <BR>SQL> select log(2,1),log(2,4)=20
from dual;</P>
<P>LOG(2,1) LOG(2,4)<BR>--------- ---------<BR>0 2<BR></P>
=
<P>26.MOD(n1,n2)<BR>=B7=B5=BB=D8=D2=BB=B8=F6n1=B3=FD=D2=D4n2=B5=C4=D3=E0=CA=
=FD<BR>SQL> select=20
mod(10,3),mod(3,3),mod(2,3) from dual;</P>
<P>MOD(10,3) MOD(3,3) MOD(2,3)<BR>--------- --------- =
---------<BR>1 0=20
2<BR></P>
<P>27.POWER<BR>=B7=B5=BB=D8n1=B5=C4n2=B4=CE=B7=BD=B8=F9<BR>SQL> =
select power(2,10),power(3,3) from=20
dual;</P>
<P>POWER(2,10) POWER(3,3)<BR>----------- ----------<BR>1024 =
27<BR></P>
=
<P>28.ROUND=BA=CDTRUNC<BR>=B0=B4=D5=D5=D6=B8=B6=A8=B5=C4=BE=AB=B6=C8=BD=F8=
=D0=D0=C9=E1=C8=EB<BR>SQL> select=20
round(55.5),round(-55.4),trunc(55.5),trunc(-55.5) from dual;</P>
<P>ROUND(55.5) ROUND(-55.4) TRUNC(55.5) =
TRUNC(-55.5)<BR>-----------=20
------------ ----------- ------------<BR>56 -55 55 -55<BR></P>
=
<P>29.SIGN<BR>=C8=A1=CA=FD=D7=D6n=B5=C4=B7=FB=BA=C5,=B4=F3=D3=DA0=B7=B5=BB=
=D81,=D0=A1=D3=DA0=B7=B5=BB=D8-1,=B5=C8=D3=DA0=B7=B5=BB=D80<BR>SQL> =
select=20
sign(123),sign(-100),sign(0) from dual;</P>
<P>SIGN(123) SIGN(-100) SIGN(0)<BR>--------- ---------- =
---------<BR>1 -1=20
0<BR></P>
=
<P>30.SIN<BR>=B7=B5=BB=D8=D2=BB=B8=F6=CA=FD=D7=D6=B5=C4=D5=FD=CF=D2=D6=B5=
<BR>SQL> select sin(1.57079) from dual;</P>
<P>SIN(1.57079)<BR>------------<BR>1<BR></P>
=
<P>31.SIGH<BR>=B7=B5=BB=D8=CB=AB=C7=FA=D5=FD=CF=D2=B5=C4=D6=B5<BR>SQL>=
select sin(20),sinh(20) from dual;</P>
<P>SIN(20) SINH(20)<BR>--------- ---------<BR>.91294525 =
242582598<BR></P>
<P>32.SQRT<BR>=B7=B5=BB=D8=CA=FD=D7=D6n=B5=C4=B8=F9<BR>SQL> =
select sqrt(64),sqrt(10) from dual;</P>
<P>SQRT(64) SQRT(10)<BR>--------- ---------<BR>8 3.1622777<BR></P>
=
<P>33.TAN<BR>=B7=B5=BB=D8=CA=FD=D7=D6=B5=C4=D5=FD=C7=D0=D6=B5<BR>SQL> =
select tan(20),tan(10) from dual;</P>
<P>TAN(20) TAN(10)<BR>--------- ---------<BR>2.2371609 =
.64836083<BR></P>
=
<P>34.TANH<BR>=B7=B5=BB=D8=CA=FD=D7=D6n=B5=C4=CB=AB=C7=FA=D5=FD=C7=D0=D6=B5=
<BR>SQL> select tanh(20),tan(20) from=20
dual;</P>
<P>TANH(20) TAN(20)<BR>--------- ---------<BR>1 2.2371609</P>
<P></P>
=
<P>35.TRUNC<BR>=B0=B4=D5=D5=D6=B8=B6=A8=B5=C4=BE=AB=B6=C8=BD=D8=C8=A1=D2=BB=
=B8=F6=CA=FD<BR>SQL> select trunc(124.1666,-2)=20
trunc1,trunc(124.16666,2) from dual;</P>
<P>TRUNC1 TRUNC(124.16666,2)<BR>--------- =
------------------<BR>100=20
124.16</P>
<P></P>
=
<P>36.ADD_MONTHS<BR>=D4=F6=BC=D3=BB=F2=BC=F5=C8=A5=D4=C2=B7=DD<BR>SQL>=
select=20
to_char(add_months(to_date('199912','yyyymm'),2),'yyyymm') from =
dual;</P>
<P>TO_CHA<BR>------<BR>200002<BR>SQL> select=20
to_char(add_months(to_date('199912','yyyymm'),-2),'yyyymm') from =
dual;</P>
<P>TO_CHA<BR>------<BR>199910<BR></P>
=
<P>37.LAST_DAY<BR>=B7=B5=BB=D8=C8=D5=C6=DA=B5=C4=D7=EE=BA=F3=D2=BB=CC=EC<=
BR>SQL> select=20
to_char(sysdate,'yyyy.mm.dd'),to_char((sysdate)+1,'yyyy.mm.dd') =
from=20
dual;</P>
<P>TO_CHAR(SY TO_CHAR((S<BR>---------- ----------<BR>2004.05.09=20
2004.05.10<BR>SQL> select last_day(sysdate) from dual;</P>
<P>LAST_DAY(S<BR>----------<BR>31-5=D4=C2 -04<BR></P>
=
<P>38.MONTHS_BETWEEN(date2,date1)<BR>=B8=F8=B3=F6date2-date1=B5=C4=D4=C2=B7=
=DD<BR>SQL> select=20
months_between('19-12=D4=C2-1999','19-3=D4=C2-1999') mon_between =
from dual;</P>
=
<P>MON_BETWEEN<BR>-----------<BR>9<BR>SQL>selectmonths_between(to_date=
('2000.05.20','yyyy.mm.dd'),to_date('2005.05.20','yyyy.mm.dd'))=20
mon_betw from dual;</P>
<P>MON_BETW<BR>---------<BR>-60<BR></P>
=
<P>39.NEW_TIME(date,'this','that')<BR>=B8=F8=B3=F6=D4=DAthis=CA=B1=C7=F8=3D=
other=CA=B1=C7=F8=B5=C4=C8=D5=C6=DA=BA=CD=CA=B1=BC=E4<BR>SQL>=20
select to_char(sysdate,'yyyy.mm.dd hh24:mi:ss')=20
bj_time,to_char(new_time<BR>2 (sysdate,'PDT','GMT'),'yyyy.mm.dd=20
hh24:mi:ss') los_angles from dual;</P>
<P>BJ_TIME LOS_ANGLES<BR>-------------------=20
-------------------<BR>2004.05.09 11:05:32 2004.05.09 =
18:05:32<BR></P>
=
<P>40.NEXT_DAY(date,'day')<BR>=B8=F8=B3=F6=C8=D5=C6=DAdate=BA=CD=D0=C7=C6=
=DAx=D6=AE=BA=F3=BC=C6=CB=E3=CF=C2=D2=BB=B8=F6=D0=C7=C6=DA=B5=C4=C8=D5=C6=
=DA<BR>SQL> select=20
next_day('18-5=D4=C2-2001','=D0=C7=C6=DA=CE=E5') next_day from =
dual;</P>
<P>NEXT_DAY<BR>----------<BR>25-5=D4=C2 -01</P>
<P></P>
=
<P>41.SYSDATE<BR>=D3=C3=C0=B4=B5=C3=B5=BD=CF=B5=CD=B3=B5=C4=B5=B1=C7=B0=C8=
=D5=C6=DA<BR>SQL> select to_char(sysdate,'dd-mm-yyyy=20
day') from dual;</P>
<P>TO_CHAR(SYSDATE,'<BR>-----------------<BR>09-05-2004=20
=
=D0=C7=C6=DA=C8=D5<BR>trunc(date,fmt)=B0=B4=D5=D5=B8=F8=B3=F6=B5=C4=D2=AA=
=C7=F3=BD=AB=C8=D5=C6=DA=BD=D8=B6=CF,=C8=E7=B9=FBfmt=3D'mi'=B1=ED=CA=BE=B1=
=A3=C1=F4=B7=D6,=BD=D8=B6=CF=C3=EB<BR>SQL> select=20
to_char(trunc(sysdate,'hh'),'yyyy.mm.dd hh24:mi:ss') hh,<BR>2=20
to_char(trunc(sysdate,'mi'),'yyyy.mm.dd hh24:mi:ss') hhmm from =
dual;</P>
<P>HH HHMM<BR>------------------- =
-------------------<BR>2004.05.09=20
11:00:00 2004.05.09 11:17:00</P>
<P></P>
=
<P>42.CHARTOROWID<BR>=BD=AB=D7=D6=B7=FB=CA=FD=BE=DD=C0=E0=D0=CD=D7=AA=BB=BB=
=CE=AAROWID=C0=E0=D0=CD<BR>SQL> select=20
rowid,rowidtochar(rowid),ename from scott.emp;</P>
<P>ROWID ROWIDTOCHAR(ROWID) ENAME<BR>------------------ =
------------------=20
----------<BR>AAAAfKAACAAAAEqAAA AAAAfKAACAAAAEqAAA=20
SMITH<BR>AAAAfKAACAAAAEqAAB AAAAfKAACAAAAEqAAB =
ALLEN<BR>AAAAfKAACAAAAEqAAC=20
AAAAfKAACAAAAEqAAC WARD<BR>AAAAfKAACAAAAEqAAD AAAAfKAACAAAAEqAAD=20
JONES<BR></P>
<P>43.CONVERT(c,dset,sset)<BR>=BD=AB=D4=B4=D7=D6=B7=FB=B4=AE =
sset=B4=D3=D2=BB=B8=F6=D3=EF=D1=D4=D7=D6=B7=FB=BC=AF=D7=AA=BB=BB=B5=BD=C1=
=ED=D2=BB=B8=F6=C4=BF=B5=C4dset=D7=D6=B7=FB=BC=AF<BR>SQL>=20
select convert('strutz','we8hp','f7dec') "conversion" from =
dual;</P>
<P>conver<BR>------<BR>strutz<BR></P>
=
<P>44.HEXTORAW<BR>=BD=AB=D2=BB=B8=F6=CA=AE=C1=F9=BD=F8=D6=C6=B9=B9=B3=C9=B5=
=C4=D7=D6=B7=FB=B4=AE=D7=AA=BB=BB=CE=AA=B6=FE=BD=F8=D6=C6<BR></P>
=
<P>45.RAWTOHEXT<BR>=BD=AB=D2=BB=B8=F6=B6=FE=BD=F8=D6=C6=B9=B9=B3=C9=B5=C4=
=D7=D6=B7=FB=B4=AE=D7=AA=BB=BB=CE=AA=CA=AE=C1=F9=BD=F8=D6=C6</P>
<P></P>
=
<P>46.ROWIDTOCHAR<BR>=BD=ABROWID=CA=FD=BE=DD=C0=E0=D0=CD=D7=AA=BB=BB=CE=AA=
=D7=D6=B7=FB=C0=E0=D0=CD</P>
<P></P>
<P>47.TO_CHAR(date,'format')<BR>SQL> select =
to_char(sysdate,'yyyy/mm/dd=20
hh24:mi:ss') from dual;</P>
<P>TO_CHAR(SYSDATE,'YY<BR>-------------------<BR>2004/05/09 =
21:14:41</P>
<P></P>
=
<P>48.TO_DATE(string,'format')<BR>=BD=AB=D7=D6=B7=FB=B4=AE=D7=AA=BB=AF=CE=
=AAORACLE=D6=D0=B5=C4=D2=BB=B8=F6=C8=D5=C6=DA<BR></P>
=
<P>49.TO_MULTI_BYTE<BR>=BD=AB=D7=D6=B7=FB=B4=AE=D6=D0=B5=C4=B5=A5=D7=D6=BD=
=DA=D7=D6=B7=FB=D7=AA=BB=AF=CE=AA=B6=E0=D7=D6=BD=DA=D7=D6=B7=FB<BR>SQL>=
; select=20
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -