Oracle Scripts » Categories » Oracle SQL tricks »

How to remove all left and right spaces from string
                                                 Last update (2008-03-04 15:18:16)
                                                                                                                   Date added (2008-03-04 15:13:45)

Summary
Use the following sql to remove all left and right spaces from a string. 
SELECT RTRIM(LTRIM('   shhdhddhffdhhfdhjfhjfjhf     ')) FROM DUAL;
Reviews
Categories
Oracle DBA-> (147)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search
 

Advanced Search
Information
Ask for Free Support
About the Author
Buy Oracle Books
Privacy Notice