OraFAQ Forum: Forms » Trimming spaces

Home » Developer & Programmer » Forms » Trimming spaces (Forms5.0)

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

Trimming spaces [message #305203]

Mon, 10 March 2008 02:45

ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore

Member

Hi All,

Declare
a varchar2(10);
Begin
select trim(' XYZXYZ ') into a from dual;
End;

It's saying trim to be declared. Whether we can use Trim function in Oracle forms? If not, any other option?
Thanks in advance.

-Karthik

Report message to a moderator

Re: Trimming spaces [message #305207 is a reply to message #305203]

Mon, 10 March 2008 02:59

irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan

Junior Member

Hello Dear

Oracle Forms 5.0 and 6.0 didn't supports trim. but you can use ltrim or rtrim or both at the same time Smile

Declare
a varchar2(10);
Begin
select rtrim(' XYZXYZ ') into a from dual;
End;

Best Regards
Muhammad Irfan Bakali

Report message to a moderator

Re: Trimming spaces [message #305227 is a reply to message #305207]

Mon, 10 March 2008 03:31

ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore

Member

Thank you. Its work fine.

Report message to a moderator

Previous Topic:	How can a variable (which contain the column name) as a column in select clause
Next Topic:	How to set Item Value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 24 11:30:18 CDT 2025