Skip to Main Content
Forums

SQL & PL/SQL

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!

how to validate email and phone number in oracle

0614Mar 6 2016 — edited Mar 7 2016

Hi all,

i have a one table

val_table

------------------------

1 email   Varchar2(25)

2 phno    Number(10)

questions:-

1.so i want do email validations and phone number validations?

2.phone number datatype already it has fixed to NUMBER(10). but i need to insert 11 number digits phone number into table dont do TABLE ALTER ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2016
Added on Mar 6 2016
5 comments
3,309 views