Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Phone number validation in varchar2 field

784804Mar 3 2011 — edited Mar 7 2011
Hello friends,

I have one database column in varchar2 , to store phone number in the format 23444-34545. [ code-phone no]
SO i want to check whether the user enter valid phone numbers in two different text fields in forms6i..ofcourse code&numbers..

My database version is : oracle 9i -9.2.0.8.0

How can i do this validation.. In oracle 9i REG-EXP is not available.So what can i do for this ?

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 4 2011
Added on Mar 3 2011
14 comments
4,230 views