📄 oracle_function_guinness.mht

📁 ORACLE函数大全--用于数据库的常用函数
💻 MHT
📖 第 1 页 / 共 5 页
字号:
12 3 4 5 下一页
From: <由 Microsoft Internet Explorer 5 保存>
Subject: =?gb2312?B?T1JBQ0xFuq/K/bTzyKstLUNOU0UuQ068vMr118rBz9bQ0MQ=?=
Date: Sun, 2 Apr 2006 00:22:30 +0800
MIME-Version: 1.0
Content-Type: multipart/related;
	boundary="----=_NextPart_000_0000_01C655EB.87825920";
	type="text/html"
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C655EB.87825920
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: quoted-printable
Content-Location: http://www.cnse.cn/html/database/oracle/602/41905.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>ORACLE=BA=AF=CA=FD=B4=F3=C8=AB--CNSE.CN=BC=BC=CA=F5=D7=
=CA=C1=CF=D6=D0=D0=C4</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dgb2312"><LINK=20
href=3D"/favicon.ico" rel=3D"SHORTCUT ICON">
<META content=3D"" name=3Dkeywords>
<META content=3D"" name=3Ddescription><LINK=20
href=3D"http://www.cnse.cn/images/css7.css" type=3Dtext/css =
rel=3Dstylesheet>
<META content=3D"MSHTML 6.00.2800.1528" name=3DGENERATOR></HEAD>
<BODY>
<CENTER><A href=3D"http://www.eb.com.cn/?flag=3D182" =
target=3D_blank><IMG height=3D80=20
src=3D"http://union.eb.com.cn/logo/778_80.gif" width=3D778 =
border=3D0></A>
<SCRIPT type=3Dtext/javascript>
var arrBaiduCproConfig=3Dnew Array();
arrBaiduCproConfig['uid'] =3D 819;
arrBaiduCproConfig['n'] =3D 'hzcnccpr';
arrBaiduCproConfig['tm'] =3D 20;
arrBaiduCproConfig['cm'] =3D 76;
arrBaiduCproConfig['um'] =3D 26;
arrBaiduCproConfig['rad'] =3D 1;
arrBaiduCproConfig['w'] =3D 728;
arrBaiduCproConfig['h'] =3D 90;
arrBaiduCproConfig['bd'] =3D '#CC0000';
arrBaiduCproConfig['bg'] =3D '#ffffff';
arrBaiduCproConfig['tt'] =3D '#0000ff';
arrBaiduCproConfig['ct'] =3D '#000000';
arrBaiduCproConfig['url'] =3D '#666666';
arrBaiduCproConfig['bdl'] =3D '#ffffff';
arrBaiduCproConfig['wn'] =3D 4;
arrBaiduCproConfig['hn'] =3D 1;
arrBaiduCproConfig['ta'] =3D 'right';
arrBaiduCproConfig['tl'] =3D 'bottom';
arrBaiduCproConfig['bu'] =3D 0;
</SCRIPT>

<SCRIPT src=3D"http://cpro.baidu.com/cpro/ui/ui.js" =
type=3Dtext/javascript>
</SCRIPT>

<SCRIPT type=3Dtext/javascript>
<!--
document.write(baiduCproIFrame());
-->
</SCRIPT>
=20
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D760 align=3Dcenter =
border=3D0>
  <TBODY>
  <TR>
    <TD align=3Dmiddle bgColor=3D#e12526 height=3D25><A =
class=3Dlink_white=20
      href=3D"http://www.cnse.cn/html/os/" =
target=3D_blank>=B2=D9=D7=F7=CF=B5=CD=B3</A> &nbsp;<A=20
      class=3Dlink_white href=3D"http://www.cnse.cn/html/program/"=20
      target=3D_blank>=B3=CC=D0=F2=C9=E8=BC=C6</A> &nbsp;<A =
class=3Dlink_white=20
      href=3D"http://www.cnse.cn/html/graphics/" =
target=3D_blank>=CD=BC=D0=CE=CD=BC=CF=F1</A> &nbsp;<A=20
      class=3Dlink_white href=3D"http://www.cnse.cn/html/mediamovice/"=20
      target=3D_blank>=C3=BD=CC=E5=B6=AF=BB=AD</A> &nbsp;<A =
class=3Dlink_white=20
      href=3D"http://www.cnse.cn/html/office/" =
target=3D_blank>=B0=EC=B9=AB=C8=ED=BC=FE</A> &nbsp;<A=20
      class=3Dlink_white href=3D"http://www.cnse.cn/html/database/" =
target=3D_blank>=20
      =CA=FD=BE=DD=BF=E2 </A>&nbsp;<A class=3Dlink_white =
href=3D"http://www.cnse.cn/html/cert/"=20
      target=3D_blank>=C8=CF=D6=A4=C5=E0=D1=B5</A> &nbsp;<A =
class=3Dlink_white=20
      href=3D"http://www.cnse.cn/html/web/" =
target=3D_blank>WEB=BF=AA=B7=A2</A> &nbsp;<A=20
      class=3Dlink_white href=3D"http://www.cnse.cn/html/net-truth/"=20
      target=3D_blank>=CD=F8=C2=E7=D4=AD=C0=ED</A> &nbsp;<A =
class=3Dlink_white=20
      href=3D"http://www.cnse.cn/html/net-manage/" =
target=3D_blank>=CD=F8=C2=E7=B9=DC=C0=ED</A> &nbsp;<A=20
      class=3Dlink_white href=3D"http://www.cnse.cn/html/net-build/"=20
      target=3D_blank>=CD=F8=C2=E7=BC=DC=C9=E8</A> &nbsp;<A =
class=3Dlink_white=20
      href=3D"http://www.cnse.cn/html/machine/"=20
      target=3D_blank>=BB=FA=D0=B5=B5=E7=D7=D3</A>&nbsp;&nbsp;<A =
class=3Dlink_white=20
      href=3D"http://www.cnse.cn/html/router/" =
target=3D_blank>=C2=B7=D3=C9=BC=BC=CA=F5</A>=20
  </TD></TR></TBODY></TABLE>
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D760 align=3Dcenter =
border=3D0>
  <TBODY>
  <TR>
    <TD align=3Dmiddle width=3D30 =
background=3Dhttp://www.cnse.cn/images/index_20.gif=20
    height=3D5></TD></TR></TBODY></TABLE>
<CENTER>
<TABLE class=3Dtable03 width=3D760 align=3Dcenter border=3D0>
  <TBODY>
  <TR>
    <TD height=3D25>=B5=B1=C7=B0=CE=BB=D6=C3:<A =
href=3D"http://www.cnse.cn/">CNSE.CN=BC=BC=CA=F5=D7=CA=C1=CF=D6=D0=D0=C4=CA=
=D7=D2=B3</A> &gt;=20
      <A =
href=3D"http://www.cnse.cn/html/database/">=CA=FD=BE=DD=BF=E2</A> &gt; =
<A=20
      href=3D"http://www.cnse.cn/html/database/oracle/">Oracle</A> &gt; =
<A=20
      =
href=3D"http://www.cnse.cn/html/database/oracle/602/">=BE=AD=D1=E9=BD=BB=C1=
=F7</A> &gt; =CE=C4=D5=C2=C4=DA=C8=DD
      <HR SIZE=3D1>
    </TD></TR>
  <TR>
    <TD>
      <DIV align=3Dcenter>
      <H2>ORACLE=BA=AF=CA=FD=B4=F3=C8=AB</H2></DIV>
      <HR SIZE=3D1>
    </TD></TR>
  <TR>
    <TD align=3Dleft width=3D720=20
    =
background=3Dhttp://www.cnse.cn/html/database/oracle/602/images/bg.JPG=20
    colSpan=3D2>
      =
<P><BR>&nbsp;<BR>SQL=D6=D0=B5=C4=B5=A5=BC=C7=C2=BC=BA=AF=CA=FD<BR>1.ASCII=
<BR>=B7=B5=BB=D8=D3=EB=D6=B8=B6=A8=B5=C4=D7=D6=B7=FB=B6=D4=D3=A6=B5=C4=CA=
=AE=BD=F8=D6=C6=CA=FD;<BR>SQL&gt;=20
      select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space =
from=20
      dual;</P>
      <P>A A ZERO SPACE<BR>--------- --------- --------- ---------<BR>65 =
97 48=20
      32<BR></P>
      =
<P>2.CHR<BR>=B8=F8=B3=F6=D5=FB=CA=FD,=B7=B5=BB=D8=B6=D4=D3=A6=B5=C4=D7=D6=
=B7=FB;<BR>SQL&gt; select chr(54740) zhao,chr(65) chr65=20
      from dual;</P>
      <P>ZH C<BR>-- -<BR>=D5=D4 A</P>
      =
<P>3.CONCAT<BR>=C1=AC=BD=D3=C1=BD=B8=F6=D7=D6=B7=FB=B4=AE;<BR>SQL&gt; =
select concat('010-','88888888')||'=D7=AA23'=20
      =B8=DF=C7=AC=BE=BA=B5=E7=BB=B0 from dual;</P>
      =
<P>=B8=DF=C7=AC=BE=BA=B5=E7=BB=B0<BR>----------------<BR>010-88888888=D7=AA=
23</P>
      =
<P>4.INITCAP<BR>=B7=B5=BB=D8=D7=D6=B7=FB=B4=AE=B2=A2=BD=AB=D7=D6=B7=FB=B4=
=AE=B5=C4=B5=DA=D2=BB=B8=F6=D7=D6=C4=B8=B1=E4=CE=AA=B4=F3=D0=B4;<BR>SQL&g=
t; select initcap('smith')=20
      upp from dual;</P>
      <P>UPP<BR>-----<BR>Smith<BR></P>
      =
<P>5.INSTR(C1,C2,I,J)<BR>=D4=DA=D2=BB=B8=F6=D7=D6=B7=FB=B4=AE=D6=D0=CB=D1=
=CB=F7=D6=B8=B6=A8=B5=C4=D7=D6=B7=FB,=B7=B5=BB=D8=B7=A2=CF=D6=D6=B8=B6=A8=
=B5=C4=D7=D6=B7=FB=B5=C4=CE=BB=D6=C3;<BR>C1 =
=B1=BB=CB=D1=CB=F7=B5=C4=D7=D6=B7=FB=B4=AE<BR>C2=20
      =CF=A3=CD=FB=CB=D1=CB=F7=B5=C4=D7=D6=B7=FB=B4=AE<BR>I =
=CB=D1=CB=F7=B5=C4=BF=AA=CA=BC=CE=BB=D6=C3,=C4=AC=C8=CF=CE=AA1<BR>J =
=B3=F6=CF=D6=B5=C4=CE=BB=D6=C3,=C4=AC=C8=CF=CE=AA1<BR>SQL&gt; select =
instr('oracle=20
      traning','ra',1,2) instring from dual;</P>
      <P>INSTRING<BR>---------<BR>9<BR></P>
      =
<P>6.LENGTH<BR>=B7=B5=BB=D8=D7=D6=B7=FB=B4=AE=B5=C4=B3=A4=B6=C8;<BR>SQL&g=
t; select=20
      name,length(name),addr,length(addr),sal,length(to_char(sal)) from=20
      gao.nchar_tst;</P>
      <P>NAME LENGTH(NAME) ADDR LENGTH(ADDR) SAL =
LENGTH(TO_CHAR(SAL))<BR>------=20
      ------------ ---------------- ------------ ---------=20
      --------------------<BR>=B8=DF=C7=AC=BE=BA 3 =
=B1=B1=BE=A9=CA=D0=BA=A3=B6=A7=C7=F8 6 9999.99 7</P>
      <P></P>
      =
<P>7.LOWER<BR>=B7=B5=BB=D8=D7=D6=B7=FB=B4=AE,=B2=A2=BD=AB=CB=F9=D3=D0=B5=C4=
=D7=D6=B7=FB=D0=A1=D0=B4<BR>SQL&gt; select lower('AaBbCcDd')AaBbCcDd=20
      from dual;</P>
      <P>AABBCCDD<BR>--------<BR>aabbccdd<BR></P>
      =
<P>8.UPPER<BR>=B7=B5=BB=D8=D7=D6=B7=FB=B4=AE,=B2=A2=BD=AB=CB=F9=D3=D0=B5=C4=
=D7=D6=B7=FB=B4=F3=D0=B4<BR>SQL&gt; select upper('AaBbCcDd') upper=20
      from dual;</P>
      <P>UPPER<BR>--------<BR>AABBCCDD</P>
      <P></P>
      <P>9.RPAD=BA=CDLPAD(=D5=B3=CC=F9=D7=D6=B7=FB)<BR>RPAD =
=D4=DA=C1=D0=B5=C4=D3=D2=B1=DF=D5=B3=CC=F9=D7=D6=B7=FB<BR>LPAD =
=D4=DA=C1=D0=B5=C4=D7=F3=B1=DF=D5=B3=CC=F9=D7=D6=B7=FB<BR>SQL&gt; select =

      lpad(rpad('gao',10,'*'),17,'*')from dual;</P>
      =
<P>LPAD(RPAD('GAO',1<BR>-----------------<BR>*******gao*******<BR>=B2=BB=B9=
=BB=D7=D6=B7=FB=D4=F2=D3=C3*=C0=B4=CC=EE=C2=FA<BR></P>
      <P>10.LTRIM=BA=CDRTRIM<BR>LTRIM =
=C9=BE=B3=FD=D7=F3=B1=DF=B3=F6=CF=D6=B5=C4=D7=D6=B7=FB=B4=AE<BR>RTRIM =
=C9=BE=B3=FD=D3=D2=B1=DF=B3=F6=CF=D6=B5=C4=D7=D6=B7=FB=B4=AE<BR>SQL&gt;=20
      select ltrim(rtrim(' gao qian jing ',' '),' ') from dual;</P>
      <P>LTRIM(RTRIM('<BR>-------------<BR>gao qian jing<BR></P>
      =
<P>11.SUBSTR(string,start,count)<BR>=C8=A1=D7=D3=D7=D6=B7=FB=B4=AE,=B4=D3=
start=BF=AA=CA=BC,=C8=A1count=B8=F6<BR>SQL&gt;=20
      select substr('13088888888',3,8) from dual;</P>
      <P>SUBSTR('<BR>--------<BR>08888888<BR></P>
      <P>12.REPLACE('string','s1','s2')<BR>string =
=CF=A3=CD=FB=B1=BB=CC=E6=BB=BB=B5=C4=D7=D6=B7=FB=BB=F2=B1=E4=C1=BF =
<BR>s1=20
      =B1=BB=CC=E6=BB=BB=B5=C4=D7=D6=B7=FB=B4=AE<BR>s2 =
=D2=AA=CC=E6=BB=BB=B5=C4=D7=D6=B7=FB=B4=AE<BR>SQL&gt; select replace('he =
love you','he','i')=20
      from dual;</P>
      <P>REPLACE('H<BR>----------<BR>i love you<BR></P>
12 3 4 5 下一页
💿 文件大小 61 K
👤 上传用户 maizhongyun
📂 所属分类数据库系统
🏷️ 相关标签

#ORACLE #函数 #数据库
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -