Exforsys

Online Training

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?...


Go Back   Exforsys > Database > Oracle Database

how do I get rid of the spaces at the how do I get rid of the spaces at the

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply

 

LinkBack Thread Tools
  #1 (permalink)  
Old 01-19-2008, 11:52 AM
Junior Member
  
Join Date: Jan 2008
Posts: 1
sql norvis is on a distinguished road
how do I get rid of the spaces at the
begining of a string in the Oracle database?
__________________
Powered by Yahoo! Answers
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 01-19-2008, 12:26 PM
Junior Member
  
Join Date: Jan 2008
Posts: 1
susanta_nj is on a distinguished road
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Oracle data pump | how can I learn Oracle? »
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

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 08:20 PM
Can some one show me some Python coding MadKad Python 8 04-30-2006 11:56 AM
Re: Name spaces in Dolphin... panu Software Patterns 11 11-22-2003 06:14 AM


All times are GMT -4. The time now is 03:10 AM.

Contact Us - Exforsys - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0
Copyright 2004 - 2007 Exforsys Inc. All rights reserved.