OraFAQ Forum: Forms » varchar2 vs number very urgent

Home » Developer & Programmer » Forms » varchar2 vs number very urgent

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

varchar2 vs number very urgent [message #84606]

Sun, 04 April 2004 01:31

Riaz
Messages: 112
Registered: February 2002

Senior Member

Dear All
I simply want a varchar2 field not to accept 0,1,2,3,...9 at any location(in the field) in forms 6i. Please help ...thanks in advance

Report message to a moderator

Re: varchar2 vs number very urgent [message #84609 is a reply to message #84606]

Mon, 05 April 2004 05:26

Bhanu
Messages: 4
Registered: February 2003

Junior Member

Hi Riaz,
Use Translate Function to solve ur problem

E.g. select Translate ('AB12CD', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789','ABCDEFGHIJKLMNOPQRSTUVWXYZ') Tr From dual

Result will be
ABCD

Try this ..
if ur problem is solved inform me..

bye
bhanu

Report message to a moderator

Re: varchar2 vs number very urgent [message #84613 is a reply to message #84609]

Mon, 05 April 2004 20:07

Riaz
Messages: 112
Registered: February 2002

Senior Member

Thanks bhanu.. The function solved my problem... But I will be thankful to you if you can explain me the following syntax...

IF TRANSLATE(:ename, '0123456789', '#') <> :ename THEN
what_ever_i_want;
..
..

Thanks for giving time...

Report message to a moderator

Previous Topic:	Registry access thru d2k
Next Topic:	opening report from within report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 06 19:07:00 CDT 2024