开发者社区> 老朱教授> 正文

ORACLE函数大全

简介:
+关注继续查看
select SEQ_DWBH.Nextval into sq_dwbm from dual;dual是虚拟表,为了配合查询
None.gifSQL中的单记录函数
None.gif1.ASCII
None.gif返回与指定的字符对应的十进制数;
None.gifSQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
None.gif
None.gif A A ZERO SPACE
None.gif--------- --------- --------- ---------
None.gif
65 97 48 32
None.gif
None.gif
None.gif2.CHR
None.gif给出整数,返回对应的字符;
None.gifSQL> select chr(54740) zhao,chr(65) chr65 from dual;
None.gif
None.gifZH C
None.gif-- -
None.gif
赵 A
None.gif
None.gif3.CONCAT
None.gif连接两个字符串;
None.gifSQL> select concat('010-','88888888')||'转23' 高乾竞电话 from dual;
None.gif
None.gif高乾竞电话
None.gif----------------
None.gif
010-88888888转23
None.gif
None.gif4.INITCAP
None.gif返回字符串并将字符串的第一个字母变为大写;
None.gifSQL> select initcap('smith') upp from dual;
None.gif
None.gifUPP
None.gif-----
None.gif
Smith
None.gif
None.gif
None.gif5.INSTR(C1,C2,I,J)
None.gif在一个字符串中搜索指定的字符,返回发现指定的字符的位置;
None.gifC1 被搜索的字符串
None.gifC2 希望搜索的字符串
None.gifI 搜索的开始位置,默认为1
None.gifJ 出现的位置,默认为1
None.gifSQL> select instr('oracle traning','ra',1,2) instring from dual;
None.gif
None.gif INSTRING
None.gif---------
None.gif
9
None.gif
None.gif
None.gif6.LENGTH
None.gif返回字符串的长度;
None.gifSQL> select name,length(name),addr,length(addr),sal,length(to_char(sal)) from gao.nchar_tst;
None.gif
None.gifNAME LENGTH(NAME) ADDR LENGTH(ADDR) SAL LENGTH(TO_CHAR(SAL))
None.gif------ ------------ ---------------- ------------ --------- --------------------
None.gif
高乾竞 3 北京市海锭区 6 9999.99 7
None.gif
None.gif
None.gif7.LOWER
None.gif返回字符串,并将所有的字符小写
None.gifSQL> select lower('AaBbCcDd')AaBbCcDd from dual;
None.gif
None.gifAABBCCDD
None.gif--------
None.gif
aabbccdd
None.gif
None.gif
None.gif8.UPPER
None.gif返回字符串,并将所有的字符大写
None.gifSQL> select upper('AaBbCcDd') upper from dual;
None.gif
None.gifUPPER
None.gif--------
None.gif
AABBCCDD
None.gif
None.gif
None.gif9.RPAD和LPAD(粘贴字符)
None.gifRPAD 在列的右边粘贴字符
None.gifLPAD 在列的左边粘贴字符
None.gifSQL> select lpad(rpad('gao',10,'*'),17,'*')from dual;
None.gif
None.gifLPAD(RPAD('GAO',1
None.gif-----------------
None.gif
*******gao*******
None.gif不够字符则用*来填满
None.gif
None.gif
None.gif10.LTRIM和RTRIM
None.gifLTRIM 删除左边出现的字符串
None.gifRTRIM 删除右边出现的字符串
None.gifSQL> select ltrim(rtrim(' gao qian jing ',' '),' ') from dual;
None.gif
None.gifLTRIM(RTRIM('
None.gif-------------
None.gifgao qian jing
None.gif
None.gif
None.gif11.SUBSTR(string,start,count)
None.gif取子字符串,从start开始,取count个
None.gifSQL> select substr(
'13088888888',3,8) from dual;
None.gif
None.gifSUBSTR(
'
None.gif--------
None.gif
08888888
None.gif
None.gif
None.gif12.REPLACE('string','s1','s2')
None.gifstring 希望被替换的字符或变量
None.gifs1 被替换的字符串
None.gifs2 要替换的字符串
None.gifSQL> select replace('he love you','he','i') from dual;
None.gif
None.gifREPLACE('H
None.gif----------
None.gifi love you
None.gif
None.gif
None.gif13.SOUNDEX
None.gif返回一个与给定的字符串读音相同的字符串
None.gifSQL> create table table1(xm varchar(8));
None.gifSQL> insert into table1 values(
'weather');
None.gifSQL> insert into table1 values(
'wether');
None.gifSQL> insert into table1 values(
'gao');
None.gif
None.gifSQL> select xm from table1 where soundex(xm)=soundex(
'weather');
None.gif
None.gifXM
None.gif--------
None.gifweather
None.gifwether
None.gif
None.gif
None.gif14.TRIM(
's' from 'string')
None.gifLEADING 剪掉前面的字符
None.gifTRAILING 剪掉后面的字符
None.gif如果不指定,默认为空格符
None.gif
None.gif15.ABS
None.gif返回指定值的绝对值
None.gifSQL> select abs(100),abs(-100) from dual;
None.gif
None.gif ABS(100) ABS(-100)
None.gif--------- ---------
None.gif 100 100
None.gif
None.gif
None.gif16.ACOS
None.gif给出反余弦的值
None.gifSQL> select acos(-1) from dual;
None.gif
None.gif ACOS(-1)
None.gif---------
None.gif3.1415927
None.gif
None.gif
None.gif17.ASIN
None.gif给出反正弦的值
None.gifSQL> select asin(0.5) from dual;
None.gif
None.gifASIN(0.5)
None.gif---------
None.gif.52359878
None.gif
None.gif
None.gif18.ATAN
None.gif返回一个数字的反正切值
None.gifSQL> select atan(1) from dual;
None.gif
None.gif ATAN(1)
None.gif---------
None.gif.78539816
None.gif
None.gif
None.gif19.CEIL
None.gif返回大于或等于给出数字的最小整数
None.gifSQL> select ceil(3.1415927) from dual;
None.gif
None.gifCEIL(3.1415927)
None.gif---------------
None.gif 4
None.gif
None.gif
None.gif20.COS
None.gif返回一个给定数字的余弦
None.gifSQL> select cos(-3.1415927) from dual;
None.gif
None.gifCOS(-3.1415927)
None.gif---------------
None.gif -1
None.gif
None.gif
None.gif21.COSH
None.gif返回一个数字反余弦值
None.gifSQL> select cosh(20) from dual;
None.gif
None.gif COSH(20)
None.gif---------
None.gif242582598
None.gif
None.gif
None.gif22.EXP
None.gif返回一个数字e的n次方根
None.gifSQL> select exp(2),exp(1) from dual;
None.gif
None.gif EXP(2) EXP(1)
None.gif--------- ---------
None.gif7.3890561 2.7182818
None.gif
None.gif
None.gif23.FLOOR
None.gif对给定的数字取整数
None.gifSQL> select floor(2345.67) from dual;
None.gif
None.gifFLOOR(2345.67)
None.gif--------------
None.gif 2345
None.gif
None.gif
None.gif24.LN
None.gif返回一个数字的对数值
None.gifSQL> select ln(1),ln(2),ln(2.7182818) from dual;
None.gif
None.gif LN(1) LN(2) LN(2.7182818)
None.gif--------- --------- -------------
None.gif 0 .69314718 .99999999
None.gif
None.gif
None.gif25.LOG(n1,n2)
None.gif返回一个以n1为底n2的对数
None.gifSQL> select log(2,1),log(2,4) from dual;
None.gif
None.gif LOG(2,1) LOG(2,4)
None.gif--------- ---------
None.gif 0 2
None.gif
None.gif
None.gif26.MOD(n1,n2)
None.gif返回一个n1除以n2的余数
None.gifSQL> select mod(10,3),mod(3,3),mod(2,3) from dual;
None.gif
None.gifMOD(10,3) MOD(3,3) MOD(2,3)
None.gif--------- --------- ---------
None.gif 1 0 2
None.gif
None.gif
None.gif27.POWER
None.gif返回n1的n2次方根
None.gifSQL> select power(2,10),power(3,3) from dual;
None.gif
None.gifPOWER(2,10) POWER(3,3)
None.gif----------- ----------
None.gif 1024 27
None.gif
None.gif
None.gif28.ROUND和TRUNC
None.gif按照指定的精度进行舍入
None.gifSQL> select round(55.5),round(-55.4),trunc(55.5),trunc(-55.5) from dual;
None.gif
None.gifROUND(55.5) ROUND(-55.4) TRUNC(55.5) TRUNC(-55.5)
None.gif----------- ------------ ----------- ------------
None.gif 56 -55 55 -55
None.gif
None.gif
None.gif29.SIGN
None.gif取数字n的符号,大于0返回1,小于0返回-1,等于0返回0
None.gifSQL> select sign(123),sign(-100),sign(0) from dual;
None.gif
None.gifSIGN(123) SIGN(-100) SIGN(0)
None.gif--------- ---------- ---------
None.gif 1 -1 0
None.gif
None.gif
None.gif30.SIN
None.gif返回一个数字的正弦值
None.gifSQL> select sin(1.57079) from dual;
None.gif
None.gifSIN(1.57079)
None.gif------------
None.gif 1
None.gif
None.gif
None.gif31.SIGH
None.gif返回双曲正弦的值
None.gifSQL> select sin(20),sinh(20) from dual;
None.gif
None.gif SIN(20) SINH(20)
None.gif--------- ---------
None.gif.91294525 242582598
None.gif
None.gif
None.gif32.SQRT
None.gif返回数字n的根
None.gifSQL> select sqrt(64),sqrt(10) from dual;
None.gif
None.gif SQRT(64) SQRT(10)
None.gif--------- ---------
None.gif 8 3.1622777
None.gif
None.gif
None.gif33.TAN
None.gif返回数字的正切值
None.gifSQL> select tan(20),tan(10) from dual;
None.gif
None.gif TAN(20) TAN(10)
None.gif--------- ---------
None.gif2.2371609 .64836083
None.gif
None.gif
None.gif34.TANH
None.gif返回数字n的双曲正切值
None.gifSQL> select tanh(20),tan(20) from dual;
None.gif
None.gif TANH(20) TAN(20)
None.gif--------- ---------
None.gif 1 2.2371609
None.gif
None.gif
None.gif35.TRUNC
None.gif按照指定的精度截取一个数
None.gifSQL> select trunc(124.1666,-2) trunc1,trunc(124.16666,2) from dual;
None.gif
None.gif TRUNC1 TRUNC(124.16666,2)
None.gif--------- ------------------
None.gif 100 124.16
None.gif
None.gif
None.gif36.ADD_MONTHS
None.gif增加或减去月份
None.gifSQL> select to_char(add_months(to_date(
'199912','yyyymm'),2),'yyyymm') from dual;
None.gif
None.gifTO_CHA
None.gif------
None.gif200002
None.gifSQL> select to_char(add_months(to_date(
'199912','yyyymm'),-2),'yyyymm') from dual;
None.gif
None.gifTO_CHA
None.gif------
None.gif199910
None.gif
None.gif
None.gif37.LAST_DAY
None.gif返回日期的最后一天
None.gifSQL> select to_char(sysdate,
'yyyy.mm.dd'),to_char((sysdate)+1,'yyyy.mm.dd') from dual;
None.gif
None.gifTO_CHAR(SY TO_CHAR((S
None.gif---------- ----------
None.gif2004.05.09 2004.05.10
None.gifSQL> select last_day(sysdate) from dual;
None.gif
None.gifLAST_DAY(S
None.gif----------
None.gif31-5月 -04
None.gif
None.gif
None.gif38.MONTHS_BETWEEN(date2,date1)
None.gif给出date2-date1的月份
None.gifSQL> select months_between(
'19-12月-1999','19-3月-1999') mon_between from dual;
None.gif
None.gifMON_BETWEEN
None.gif-----------
None.gif 9
None.gifSQL>selectmonths_between(to_date(
'2000.05.20','yyyy.mm.dd'),to_date('2005.05.20','yyyy.mm.dd')) mon_betw from dual;
None.gif
None.gif MON_BETW
None.gif---------
None.gif -60
None.gif
None.gif
None.gif39.NEW_TIME(date,
'this','that')
None.gif给出在this时区=other时区的日期和时间
None.gifSQL> select to_char(sysdate,
'yyyy.mm.dd hh24:mi:ss') bj_time,to_char(new_time
None.gif 2 (sysdate,
'PDT','GMT'),'yyyy.mm.dd hh24:mi:ss') los_angles from dual;
None.gif
None.gifBJ_TIME LOS_ANGLES
None.gif------------------- -------------------
None.gif2004.05.09 11:05:32 2004.05.09 18:05:32
None.gif
None.gif
None.gif40.NEXT_DAY(date,
'day')
None.gif给出日期date和星期x之后计算下一个星期的日期
None.gifSQL> select next_day(
'18-5月-2001','星期五') next_day from dual;
None.gif
None.gifNEXT_DAY
None.gif----------
None.gif25-5月 -01
None.gif
None.gif
None.gif41.SYSDATE
None.gif用来得到系统的当前日期
None.gifSQL> select to_char(sysdate,
'dd-mm-yyyy day') from dual;
None.gif
None.gifTO_CHAR(SYSDATE,
'
None.gif-----------------
None.gif
09-05-2004 星期日
None.giftrunc(date,fmt)按照给出的要求将日期截断,如果fmt='mi'表示保留分,截断秒
None.gifSQL> select to_char(trunc(sysdate,'hh'),'yyyy.mm.dd hh24:mi:ss') hh,
None.gif2 to_char(trunc(sysdate,'mi'),'yyyy.mm.dd hh24:mi:ss') hhmm from dual;
None.gif
None.gifHH HHMM
None.gif------------------- -------------------
None.gif
2004.05.09 11:00:00 2004.05.09 11:17:00
None.gif
None.gif
None.gif42.CHARTOROWID
None.gif将字符数据类型转换为ROWID类型
None.gifSQL> select rowid,rowidtochar(rowid),ename from scott.emp;
None.gif
None.gifROWID ROWIDTOCHAR(ROWID) ENAME
None.gif------------------ ------------------ ----------
None.gif
AAAAfKAACAAAAEqAAA AAAAfKAACAAAAEqAAA SMITH
None.gifAAAAfKAACAAAAEqAAB AAAAfKAACAAAAEqAAB ALLEN
None.gifAAAAfKAACAAAAEqAAC AAAAfKAACAAAAEqAAC WARD
None.gifAAAAfKAACAAAAEqAAD AAAAfKAACAAAAEqAAD JONES
None.gif
None.gif
None.gif43.CONVERT(c,dset,sset)
None.gif将源字符串 sset从一个语言字符集转换到另一个目的dset字符集
None.gifSQL> select convert('strutz','we8hp','f7dec') "conversion" from dual;
None.gif
None.gifconver
None.gif------
None.gif
strutz
None.gif
None.gif
None.gif44.HEXTORAW
None.gif将一个十六进制构成的字符串转换为二进制
None.gif
None.gif
None.gif45.RAWTOHEXT
None.gif将一个二进制构成的字符串转换为十六进制
None.gif
None.gif
None.gif46.ROWIDTOCHAR
None.gif将ROWID数据类型转换为字符类型
None.gif
None.gif
None.gif47.TO_CHAR(date,'format')
None.gifSQL> select to_char(sysdate,'yyyy/mm/dd hh24:mi:ss') from dual;
None.gif
None.gifTO_CHAR(SYSDATE,'YY
None.gif-------------------
None.gif2004/05/09 21:14:41
None.gif
None.gif
None.gif48.TO_DATE(string,
'format')
None.gif将字符串转化为ORACLE中的一个日期
None.gif
None.gif
None.gif49.TO_MULTI_BYTE
None.gif将字符串中的单字节字符转化为多字节字符
None.gifSQL> select to_multi_byte(
'') from dual;
None.gif
None.gifTO
None.gif--
None.gif
None.gif
None.gif
None.gif50.TO_NUMBER
None.gif将给出的字符转换为数字
None.gifSQL> select to_number(
'1999') year from dual;
None.gif
None.gif YEAR
None.gif---------
None.gif 1999
None.gif
None.gif
None.gif51.BFILENAME(dir,file)
None.gif指定一个外部二进制文件
None.gifSQL>insert into file_tb1 values(bfilename(
'lob_dir1','image1.gif'));
None.gif
None.gif
None.gif52.CONVERT(
'x','desc','source')
None.gif将x字段或变量的源source转换为desc
None.gifSQL> select sid,serial#,username,decode(command,
None.gif 2 0,
'none',
None.gif 3 2,
'insert',
None.gif 4 3,
None.gif 5
'select',
None.gif 6 6,
'update',
None.gif 7 7,
'delete',
None.gif 8 8,
'drop',
None.gif 9
'other') cmd from v$session where type!='background';
None.gif
None.gif SID SERIAL# USERNAME CMD
None.gif--------- --------- ------------------------------ ------
None.gif 1 1 none
None.gif 2 1 none
None.gif 3 1 none
None.gif 4 1 none
None.gif 5 1 none
None.gif 6 1 none
None.gif 7 1275 none
None.gif 8 1275 none
None.gif 9 20 GAO select
None.gif 10 40 GAO none
None.gif
None.gif
None.gif53.DUMP(s,fmt,start,length)
None.gifDUMP函数以fmt指定的内部数字格式返回一个VARCHAR2类型的值
None.gifSQL> col global_name for a30
None.gifSQL> col dump_string for a50
None.gifSQL> set lin 200
None.gifSQL> select global_name,dump(global_name,1017,8,5) dump_string from global_name;
None.gif
None.gifGLOBAL_NAME DUMP_STRING
None.gif------------------------------ --------------------------------------------------
None.gifORACLE.WORLD Typ=1 Len=12 CharacterSet=ZHS16GBK: W,O,R,L,D
None.gif
None.gif
None.gif54.EMPTY_BLOB()和EMPTY_CLOB()
None.gif这两个函数都是用来对大数据类型字段进行初始化操作的函数
None.gif
None.gif
None.gif55.GREATEST
None.gif返回一组表达式中的最大值,即比较字符的编码大小.
None.gifSQL> select greatest(
'AA','AB','AC') from dual;
None.gif
None.gifGR
None.gif--
None.gifAC
None.gifSQL> select greatest(
'','','') from dual;
None.gif
None.gifGR
None.gif--
None.gif
None.gif
None.gif
None.gif56.LEAST
None.gif返回一组表达式中的最小值
None.gifSQL> select least(
'','','') from dual;
None.gif
None.gifLE
None.gif--
None.gif
None.gif
None.gif
None.gif57.UID
None.gif返回标识当前用户的唯一整数
None.gifSQL> show user
None.gifUSER 为"GAO"
None.gifSQL> select username,user_id from dba_users where user_id=uid;
None.gif
None.gifUSERNAME USER_ID
None.gif------------------------------ ---------
None.gifGAO 25
None.gif
None.gif
None.gif58.USER
None.gif返回当前用户的名字
None.gifSQL> select user from dual;
None.gif
None.gifUSER
None.gif------------------------------
None.gifGAO
None.gif
None.gif
None.gif59.USEREVN
None.gif返回当前用户环境的信息,opt可以是:
None.gifENTRYID,SESSIONID,TERMINAL,ISDBA,LABLE,LANGUAGE,CLIENT_INFO,LANG,VSIZE
None.gifISDBA 查看当前用户是否是DBA如果是则返回true
None.gifSQL> select userenv(
'isdba') from dual;
None.gif
None.gifUSEREN
None.gif------
None.gifFALSE
None.gifSQL> select userenv(
'isdba') from dual;
None.gif
None.gifUSEREN
None.gif------
None.gifTRUE
None.gifSESSION
None.gif返回会话标志
None.gifSQL> select userenv(
'sessionid') from dual;
None.gif
None.gifUSERENV(
'SESSIONID')
None.gif--------------------
None.gif 152
None.gifENTRYID
None.gif返回会话人口标志
None.gifSQL> select userenv(
'entryid') from dual;
None.gif
None.gifUSERENV(
'ENTRYID')
None.gif------------------
None.gif 0
None.gifINSTANCE
None.gif返回当前INSTANCE的标志
None.gifSQL> select userenv(
'instance') from dual;
None.gif
None.gifUSERENV(
'INSTANCE')
None.gif-------------------
None.gif 1
None.gifLANGUAGE
None.gif返回当前环境变量
None.gifSQL> select userenv(
'language') from dual;
None.gif
None.gifUSERENV(
'LANGUAGE')
None.gif----------------------------------------------------
None.gifSIMPLIFIED CHINESE_CHINA.ZHS16GBK
None.gifLANG
None.gif返回当前环境的语言的缩写
None.gifSQL> select userenv(
'lang') from dual;
None.gif
None.gifUSERENV(
'LANG')
None.gif----------------------------------------------------
None.gifZHS
None.gifTERMINAL
None.gif返回用户的终端或机器的标志
None.gifSQL> select userenv(
'terminal') from dual;
None.gif
None.gifUSERENV(
'TERMINA
None.gif----------------
None.gif
GAO
None.gifVSIZE(X)
None.gif返回X的大小(字节)数
None.gifSQL> select vsize(user),user from dual;
None.gif
None.gifVSIZE(USER) USER
None.gif----------- ------------------------------
None.gif
6 SYSTEM
None.gif
None.gif
None.gif60.AVG(DISTINCT|ALL)
None.gifall表示对所有的值求平均值,distinct只对不同的值求平均值
None.gifSQLWKS> create table table3(xm varchar(8),sal number(7,2));
None.gif语句已处理。
None.gifSQLWKS> insert into table3 values('gao',1111.11);
None.gifSQLWKS> insert into table3 values('gao',1111.11);
None.gifSQLWKS> insert into table3 values('zhu',5555.55);
None.gifSQLWKS> commit;
None.gif
None.gifSQL> select avg(distinct sal) from gao.table3;
None.gif
None.gifAVG(DISTINCTSAL)
None.gif----------------
None.gif
3333.33
None.gif
None.gifSQL> select avg(all sal) from gao.table3;
None.gif
None.gifAVG(ALLSAL)
None.gif-----------
None.gif
2592.59
None.gif
None.gif
None.gif61.MAX(DISTINCT|ALL)
None.gif求最大值,ALL表示对所有的值求最大值,DISTINCT表示对不同的值求最大值,相同的只取一次
None.gifSQL> select max(distinct sal) from scott.emp;
None.gif
None.gifMAX(DISTINCTSAL)
None.gif----------------
None.gif
5000
None.gif
None.gif
None.gif62.MIN(DISTINCT|ALL)
None.gif求最小值,ALL表示对所有的值求最小值,DISTINCT表示对不同的值求最小值,相同的只取一次
None.gifSQL> select min(all sal) from gao.table3;
None.gif
None.gifMIN(ALLSAL)
None.gif-----------
None.gif
1111.11
None.gif
None.gif
None.gif63.STDDEV(distinct|all)
None.gif求标准差,ALL表示对所有的值求标准差,DISTINCT表示只对不同的值求标准差
None.gifSQL> select stddev(sal) from scott.emp;
None.gif
None.gifSTDDEV(SAL)
None.gif-----------
None.gif
1182.5032
None.gif
None.gifSQL> select stddev(distinct sal) from scott.emp;
None.gif
None.gifSTDDEV(DISTINCTSAL)
None.gif-------------------
None.gif
1229.951
None.gif
None.gif
None.gif64.VARIANCE(DISTINCT|ALL)
None.gif求协方差
None.gif
None.gifSQL> select variance(sal) from scott.emp;
None.gif
None.gifVARIANCE(SAL)
None.gif-------------
None.gif
1398313.9
None.gif
None.gif
None.gif65.GROUP BY
None.gif主要用来对一组数进行统计
None.gifSQL> select deptno,count(*),sum(sal) from scott.emp group by deptno;
None.gif
None.gif DEPTNO COUNT(*) SUM(SAL)
None.gif--------- --------- ---------
None.gif
10 3 8750
None.gif20 5 10875
None.gif30 6 9400
None.gif
None.gif
None.gif66.HAVING
None.gif对分组统计再加限制条件
None.gifSQL> select deptno,count(*),sum(sal) from scott.emp group by deptno having count(*)>=5;
None.gif
None.gif DEPTNO COUNT(*) SUM(SAL)
None.gif--------- --------- ---------
None.gif
20 5 10875
None.gif30 6 9400
None.gifSQL> select deptno,count(*),sum(sal) from scott.emp having count(*)>=5 group by deptno ;
None.gif
None.gif DEPTNO COUNT(*) SUM(SAL)
None.gif--------- --------- ---------
None.gif
20 5 10875
None.gif30 6 9400
None.gif
None.gif
None.gif67.ORDER BY
None.gif用于对查询到的结果进行排序输出
None.gifSQL> select deptno,ename,sal from scott.emp order by deptno,sal desc;
None.gif
None.gif DEPTNO ENAME SAL
None.gif--------- ---------- ---------
None.gif
10 KING 5000
None.gif10 CLARK 2450
None.gif10 MILLER 1300
None.gif20 SCOTT 3000
None.gif20 FORD 3000
None.gif20 JONES 2975
None.gif20 ADAMS 1100
None.gif20 SMITH 800
None.gif30 BLAKE 2850
None.gif30 ALLEN 1600
None.gif30 TURNER 1500
None.gif30 WARD 1250
None.gif30 MARTIN 1250
None.gif30 JAMES 950



本文转自高海东博客园博客,原文链接:http://www.cnblogs.com/ghd258/archive/2005/10/28/264058.html,如需转载请自行联系原作者

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

相关文章
Oracle Ascii& Asciistr()函数使用介绍以及常用字符ASCII码对应表
Asciistr ASCII chr(9) tab空格 chr(10) 换行 chr(13) 回车 Chr(13)&chr(10) 回车换行 chr(32) 空格符 chr(34) 双引号 chr(39) 单引号 chr(33) ! chr(34) " chr(35) # chr(36) $ ...
16 0
Oracle数据库中通用的函数
Oracle数据库中的函数 🍅程序员小王的博客:程序员小王的博客 🍅 欢迎点赞 👍 收藏 ⭐留言 📝 🍅 如有编辑错误联系作者,如果有比较好的文章欢迎分享给我,我会取其精华去其糟粕 🍅java自学的学习路线:java自学的学习路线
25 0
Oracle简单查询、条件查询、枚举查询、模糊查询、排序查询、函数查询等
Oracle简单查询、条件查询、枚举查询、模糊查询、排序查询、函数查询等
39 0
Oracle的SYS_GUID() 函数
大家好呀,我是柚子,这篇文章来介绍下Oracle的SYS_GUID() 函数。~~( ̄︶ ̄*))~
56 0
oracle中使用sql查询时字段为空 赋值默认值 ( 通过 nvl( )函数 )
oracle中使用sql查询时字段为空 赋值默认值 ( 通过 nvl( )函数 )
112 0
Oracle行转列函数PRINT_TABLE的用法
Oracle行转列函数PRINT_TABLE的用法
31 0
8-Oracle函数有哪些
了解8-Oracle函数有哪些。
70 0
Oracle语句判断字符串是否为数字及translate函数解析
Oracle语句判断字符串是否为数字及translate函数解析
103 0
+关注
文章
问答
文章排行榜
最热
最新
相关电子书
更多
EasyDBforOracle— 基于阿里云的Oracle最佳实践
立即下载
Oracle云上最佳实践
立即下载
迁移 ORACLE 最佳实践
立即下载