Home » SQL & PL/SQL » SQL & PL/SQL » how to reject trailing spaces?
how to reject trailing spaces? [message #292032] Mon, 07 January 2008 09:02 Go to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Hi

i am retrieving data from text file using utl_file. My max data length is 15 chars. I retrived the data using substr. but now the problem is that it contains the trailing spaces. When i am printing those values to a text file i dont want to print the trailing spaces. How to neglect the trailing spaces?

for example there is a data "dgfdtrd" as i m geting the data by substr it contains 8 trailing spaces.
Re: how to reject trailing spaces? [message #292033 is a reply to message #292032] Mon, 07 January 2008 09:03 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
TRIM
Previous Topic: how to insert data from one table to another table
Next Topic: Using WITH clause with DML Statements
Goto Forum:
  


Current Time: Sat Dec 10 12:40:55 CST 2016

Total time taken to generate the page: 0.15982 seconds