Hi,
What is the procedure to use trim function inside a pl/sql block in oracle forms.
For ex : To trim the character ","
select trim(',' from ',street1') from dual ;
gives required output.
Now, if I would like to use it in forms on a variable then the following doesn't work
select trim(',' from 'v_strt_addr') into v1 from dual;
It gives, Encountered the symbol "FROM' when expecting one of the following.....error.
Please help.