14 Replies Latest reply on Mar 7, 2011 12:41 PM by Amatu Allah Neveen Ebrahim

    Phone number validation in varchar2 field

      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 -

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