Home » Other » Training & Certification » field validation
icon10.gif  field validation [message #274717] Tue, 16 October 2007 23:09 Go to next message
Messages: 1
Registered: October 2007
Location: COLORADO
Junior Member
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 #274731 is a reply to message #274717] Wed, 17 October 2007 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hace a look at check constraint and regexp_like condition or translate function.


[Updated on: Wed, 17 October 2007 00:57]

Report message to a moderator

Re: field validation [message #274922 is a reply to message #274717] Wed, 17 October 2007 13:08 Go to previous message
Bill B
Messages: 1474
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.
Previous Topic: Search for PL/SQL books
Goto Forum:

Current Time: Wed Oct 26 06:23:17 CDT 2016

Total time taken to generate the page: 0.06603 seconds