2013年(14)
发布时间:2013-08-15 16:15:15
with a as(select 'abcdeft' as a1 from dualunion allselect 'aaabbb' as a1 from dual)select regexp_replace(a.a1,'(...)(.+$)','\1123\2') from a; REGEXP_REPLACE(A.A1,'(...)(.+$-----------------.........【阅读全文】
发布时间:2013-08-02 08:40:25
ORACLE 二进制 十进制 十六进制的转换 十进制 ==> 十六进制 SQL> select to_char(10,'xx') from dual;TO_CHAR(10,'xx')---------------- a十六进制 ==> 十进制.........【阅读全文】
发布时间:2013-08-01 22:32:38
点击(此处)折叠或打开SYS_CONNECT_BY_PATH 函数用法 SELECT ename SELECT SYS_CONNECT_BY_PATH(ename, '>') "Path" FROM emp FROM emp START WITH ename = 'KING' START WITH ename = .........【阅读全文】