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

Regards
Michel

[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: 1482
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
Next Topic: NULL RESOLUTION
Goto Forum:
  


Current Time: Sat Dec 03 08:06:43 CST 2016

Total time taken to generate the page: 0.06047 seconds