目 錄
目 錄 1
查看回滾段名稱及大小 3
ASCII 3
CHR 3
CONCAT 4
INITCAP 4
INSTR(C1,C2,I,J) 4
LENGTH 4
LOWER 5
UPPER 5
RPAD和LPAD(粘貼字符) 5
LTRIM和RTRIM 5
SUBSTR(string,start,count) 6
REPLACE('string','s1','s2') 6
SOUNDEX 6
TRIM('s' from 'string') 7
ABS 7
ACOS 7
ASIN 7
ATAN 7
CEIL 8
COS 8
COSH 8
EXP 8
FLOOR 8
LN 9
LOG(n1,n2) 9
MOD(n1,n2) 9
POWER 9
ROUND和TRUNC 10
SIGN 10
SIN 10
SIGH 10
SQRT 10
TAN 11
TANH 11
TRUNC 11
ADD_MONTHS 11
LAST_DAY 12
MONTHS_BETWEEN(date2,date1) 12
NEW_TIME(date,'this','that') 12
NEXT_DAY(date,'day') 13
SYSDATE 13
CHARTOROWID 13
CONVERT(c,dset,sset) 14
HEXTORAW 14
RAWTOHEXT 14
ROWIDTOCHAR 14
TO_CHAR(date,'format') 14
TO_DATE(string,'format') 14
TO_MULTI_BYTE 15
TO_NUMBER 15
BFILENAME(dir,file) 15
CONVERT('x','desc','source') 15
DUMP(s,fmt,start,length) 16
EMPTY_BLOB()和EMPTY_CLOB() 16
GREATEST 16
LEAST 17
UID 17
USER 17
USEREVN 17
AVG(DISTINCT|ALL) 19
MAX(DISTINCT|ALL) 19
MIN(DISTINCT|ALL) 20
STDDEV(distinct|all) 20
VARIANCE(DISTINCT|ALL) 20
GROUP BY 20
HAVING 21
ORDER BY 21
查看回滾段名稱及大小
select segment_name, tablespace_name, r.status, (initial_extent/1024) InitialExtent,(next_extent/1024) NextExtent,
max_extents, v.curext CurExtent
From dba_rollback_segs r, v$rollstat v
Where r.segment_id = v.usn(+)
order by segment_name;
ASCII
返回與指定的字符對應的十進制數;
SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
CHR
給出整數,返回對應的字符;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- -
趙 A
CONCAT
連接兩個字符串;
SQL> select concat('010-','88888888')||'轉23' 高乾競電話 from dual;
|
|
資源大小：25.06 KB 
