摘要:
1. ASCII 返回与指定的字符对应的十进制数; SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual; A A ZERO SPACE --------- --------- --------- --------- 65 97 48 32 2. CHR 给出整数,返回对应的字符; SQ... 阅读全文
摘要:
--方法1: with tmp as ( select '按时的撒旦123元(其中含存款11元)' name from dual union all select '一类似的预存9600元(新势力)' from dual ) select name,trim(translate( substr(name,1,instr(name... 阅读全文
摘要:
数学函数 1.绝对值 S:select abs(-1) value O:select abs(-1) value from dual 2.取整(大) S:select ceiling(-1.001) value O:select ceil(-1.001) value from dual 3.取整(小) S:select floor(-1.001) value O:selec... 阅读全文
摘要:
--创建测试表 create table test(id number, name varchar2(20)); insert into test(id, name) values(1,'10'); insert into test(id, name) values(1,'10'); insert into test(id, name) values(2,'20'); insert into t... 阅读全文
摘要:
--1.监控undo空间情况 select tablespace_name,round(sum(bytes)/(1024*1024),2) free_space from dba_free_space where tablespace_name='UNDOTBS1' group by tablespace_name; TABLESPACE_NAME FREE_SPACE -------... 阅读全文
摘要:
--实现1: select r1 || '*' || r1 || '=' || r1 * r1 A, decode(r2, '', '', r2 || '*' || r1 || '=' || r2 * r1) b, decode(r3, '', '', r3 || '*' || r1 || '=' || r3 * r1) C, decode(r4, ''... 阅读全文