Home » Developer & Programmer » Forms » Trimming spaces (Forms5.0)
Trimming spaces [message #305203] Mon, 10 March 2008 02:45 Go to next message
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

Re: Trimming spaces [message #305207 is a reply to message #305203] Mon, 10 March 2008 02:59 Go to previous messageGo to next message
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
Re: Trimming spaces [message #305227 is a reply to message #305207] Mon, 10 March 2008 03:31 Go to previous message
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
Member
Thank you. Its work fine.
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:
  


Current Time: Wed Dec 07 12:30:47 CST 2016

Total time taken to generate the page: 0.23053 seconds