14 Replies Latest reply: Mar 7, 2011 4:41 AM by Amatu Allah Neveen Ebrahim RSS

    Phone number validation in varchar2 field

    784804
      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 ?