Advanced Search

Return to Snippet

Revision: 8441
at September 22, 2008 00:58 by jamarama
Initial Code 
SELECT REGEXP_REPLACE(
    'string'
    , '^([[:space:]]|'||CHR(9)||'|'||CHR(10)||'|'||CHR(13)||')+|([[:space:]]|'||CHR(9)||'|'||CHR(10)||'|'||CHR(13)||')+$', '*') AS result
  FROM dual;
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Trim TAB/CR/LF/Space from string

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
regex

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PL/SQL