field validation [message #274717] |
Tue, 16 October 2007 23:09 |
vinny950
Messages: 1 Registered: October 2007 Location: COLORADO
|
Junior Member |
|
|
Hi
I am really realy new in plsql.
Here is my problem.I have a table with two fields one field only accept CHARACTERS BETWEEN 0-9.SO I WANT TO VALIDATE THIS FIELD SO THAT WHEN THE USER TRY TO INSERT CHARATERS OTHER THAN 023456789, I WOULD LIKE THE DATABASE TO DETECT BY RAISING AN ERROR.Any help is appreciated.thanks
|
|
|
|
Re: field validation [message #274922 is a reply to message #274717] |
Wed, 17 October 2007 13:08 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
Also if the column is only going to accept numeric characters, why not make it a number column? It makes no sense to make it character.
|
|
|