how do I get rid of the spaces at the
This is a discussion on how do I get rid of the spaces at the within the Oracle Database forums, part of the Database category; begining of a string in the Oracle database?...
|
|||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
01-19-2008, 10:52 AM
|
|||
|
|||
|
how do I get rid of the spaces at the
begining of a string in the Oracle database?
__________________
Powered by Yahoo! Answers     
|
| Sponsored Links |
|
01-19-2008, 11:26 AM
|
|||
|
|||
|
You can use "trim()" function to do that. Look at Oracle SQL Manual to find out how to use trim() function. If you want to correct data in a table to get rid of leading spaces, use Update with trim function. Did a google search with "oracle trim function" and got lots of hits.
www.google.com
__________________
Powered by Yahoo! Answers
|
| Sponsored Links |
 |
| Thread Tools | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to achieve this - Minimum Code to Strip Blank Spaces | norman | C and C++ | 3 | 06-17-2006 07:20 PM |
| Can some one show me some Python coding | MadKad | Python | 8 | 04-30-2006 10:56 AM |
| Re: Name spaces in Dolphin... | panu | Software Patterns | 11 | 11-22-2003 05:14 AM |
All times are GMT -4. The time now is 09:23 PM.
