Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Length() of a string

PandeeshJul 30 2011 — edited Jul 30 2011
Hi,

By default ,if we execute the query

SELECT LENGTH('1 ') FROM DUAL,

It will return 3 as length.

But i don't want to calculate length including the spaces in the right.

Is there any other built in function available in Oracle which returns the length of the string without the spaces in the right. (i,e 1 for the above case).

Thanks
This post has been answered by JustinCave on Jul 30 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2011
Added on Jul 30 2011
1 comment
417 views