pl/sql中的case语句
select initcap('dfdsj') from dual;
select replace('ddff','f','') from dual;
select translate('ddff','f','d') from dual;
select substr('asdfjkl',1,4) from dual;
select current_date from dual;
select sysdate from dual;
select concat('010-','88888888')||'转23 高乾竞电话' from dual
select extract(year from sysdate) from dual;
select instr('oracle traning','ra',1,2) instring from dual;
select lpad(rpad('gao',10,'*'),17,'*')from dual;
select rpad('gao',10,'*') from dual;
select replace('1,23,333,000.00',',','') jine from dual;
select trim(' ddd  ') from dual;
select to_char(sysdate,'dd'),to_char((sysdate)+1,'dd') fr
select to_date('2010-01-11', 'YYYY-MM-DD') from dual;
select months_between('19-12月-1999','19-3月-1999') mon_between from dual;
select to_char(trunc(sysdate,'hh'),'dd hh24:mi:ss') hh,to_char(trunc(sysdate,'mi'),'dd hh24:mi:ss') hhmm from dua
select user from dual;
oracle切割字符串函数
select deptno,count(*),sum(sal) p group by deptno;
select decode(1 , 1 , 'x is 1', 2 , 'x is 2', 'others') from dual;

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。