OraFAQ Forum: Reports & Discoverer » SQL

Home » Developer & Programmer » Reports & Discoverer » SQL - spaces in cols.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL - spaces in cols. [message #391395]

Thu, 12 March 2009 02:02

Maverick27
Messages: 84
Registered: October 2008

Member

Can somebody pls. remind the syntax for removing spaces in column when joining SQLs.

I suspect that it definitely the issue of space for the discrepancy in the SQL statements as per attachment.

So when i am joining 2 matching columns from tables i want to get the correct result.

Mave

Attachment: sql.jpg
(Size: 29.70KB, Downloaded 835 times)

Report message to a moderator

Re: SQL - spaces in cols. [message #391399 is a reply to message #391395]

Thu, 12 March 2009 02:20

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm sorry, but I didn't understand the question, nor the image. What "space" are you talking about?

Report message to a moderator

Re: SQL - spaces in cols. [message #391456 is a reply to message #391395]

Thu, 12 March 2009 05:29

azamkhan
Messages: 557
Registered: August 2005

Senior Member

use RTRIM() function to remove the spaces...

Regards,
Azam Khan

Report message to a moderator

Re: SQL - spaces in cols. [message #391458 is a reply to message #391399]

Thu, 12 March 2009 05:30

Maverick27
Messages: 84
Registered: October 2008

Member

Littlefoot wrote on Thu, 12 March 2009 02:20

I'm sorry, but I didn't understand the question, nor the image. What "space" are you talking about?

No worries Big Foot >> use of RTRIM to removes spaces

MAve

Report message to a moderator

Re: SQL - spaces in cols. [message #391510 is a reply to message #391458]

Thu, 12 March 2009 07:27

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

OK, if you say so. I must be quite stupid for not seeing something so obvious to the others.

Report message to a moderator

Re: SQL - spaces in cols. [message #394680 is a reply to message #391395]

Sun, 29 March 2009 13:50

jaganerp@gmail.com
Messages: 63
Registered: April 2008

Member

Hai by using like operation only you can fetch teh values only

see this syntax:

select column_name from table where name like 'Value%' or'%value'

uyou can use only with % symbole, but you can not use any value without % and ' ' like tis

Report message to a moderator

Previous Topic:	'Error Suppression' in Oracle Report Builder
Next Topic:	Passing value across worksheets is possible ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 06:22:53 CST 2024