页面历史

select chr(92)||'1XXXX' from dual;
--正则表达式转义
select chr(94)||chr(92)||'d{10}$' from dual
select chr(91)||'0-9'||chr(93)||'*'||chr(91)||'0-9'||chr(93) as a from dual

select to_number(regexp_substr('20180721',chr(91)||'0-9'||chr(93)||'*'||chr(91)||'0-9'||chr(93),1)) from dual;


SELECT REPLACE(CHR(10),'\n') FROM dual
SELECT REPLACE(CHR(10),concat(chr(92),'n'))  as  a  FROM dual

select cast(concat(char(91),'123',char(93),'hao',char(58))as char) as a

select concat('a','123','hao') as a

select substring('[123]hao:','^\[.+\](.+):');
select substring('[123]hao:',chr(94) || E'\\[.+\\](.+):');