Phone number validation in varchar2 field
784804Mar 3 2011 — edited Mar 7 2011Hello 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 ?