OraFAQ Forum: Forms » char display right to left

Home » Developer & Programmer » Forms » char display right to left (Froms 6i, Database 10g)

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

char display right to left [message #501964]

Fri, 01 April 2011 13:41

roni32
Messages: 1
Registered: April 2011

Junior Member

Hello

I am using forms 6i and oracle 10g. i want to display a char from database. that means a database string 'Bangladesh' is display from
by one char to one char.

and display view right to left

first display "B" then "BA" then 'BAN' etc

thanks

Report message to a moderator

Re: char display right to left [message #501967 is a reply to message #501964]

Fri, 01 April 2011 15:18

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Use the

reverse

function.

Forms 6i might not support this. In that case, make a stored procedure to do it for you and call the stored procedure.

Report message to a moderator

Re: char display right to left [message #501989 is a reply to message #501967]

Sat, 02 April 2011 02:26

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Please try this code.

Set Serveroutput on
Declare
A Varchar2(15):='Bangladesh';
B Number;
C Varchar2(15);

Begin

Select Length(A) Into B From Dual;

For i in 1.. b loop

C:=substr(A,1,i);

dbms_output.put_line('Value of String .. '||C);

end loop;

End;

Output'll be.

Value of String .. B
Value of String .. Ba
Value of String .. Ban
Value of String .. Bang
Value of String .. Bangl
Value of String .. Bangla
Value of String .. Banglad
Value of String .. Banglade
Value of String .. Banglades
Value of String .. Bangladesh

Hope it'll help you.

Regards,
Irfan

Report message to a moderator

Previous Topic:	Thinking outside the box form design assistance
Next Topic:	Problem(Call reports from oracle forms)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 05:11:00 CDT 2024