Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getPrintedValues(p_string varchar2)
- return varchar2
- is
- l_new_string varchar2(32700);
- l_redex varchar2(50) := '[^ -~]';
- begin
- SELECT REPLACE(REPLACE(REPLACE(REGEXP_REPLACE(p_string, l_redex, ''), '[CR-LF]', '' ),chr(9),''),chr(10),'8')
- into l_new_string
- from dual;
- return l_new_string;
- end;
- ----------------------------
- select trim(' ' FROM trim( ' PC FDC Warehouse' )) from dual -- ok
- /
- select trim(CHR(9) FROM trim( ' PC FDC Warehouse' )) from dual
- /
- select trim( ' PC FDC Warehouse' ) from dual
- /
- select ASCIISTR( ' PC FDC Warehouse' ) from dual
- /
- SELECT translate(
- translate(
- translate(' PC FDC Warehouse', CHR(10), '')
- , CHR(13), '')
- , CHR(09), '') as massaged
- FROM dual;
- /
- SELECT REGEXP_REPLACE(' PC FDC Warehouse', '[^ -~]','') from dual
- /
- select wims_aop_qry_rep_pkg.getPrintedValues(' PC FDC Warehouse') from dual
- /
- select dump(' PC FDC Warehouse') from dual;
- /
- select trim(replace(replace(replace(' PC FDC Warehouse',chr(9),''),chr(10),''),chr(13),'')) from dual
- -------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement