Home » SQL & PL/SQL » SQL & PL/SQL » CHECK data type in SQL
CHECK data type in SQL [message #209983] Mon, 18 December 2006 18:44 Go to next message
pmouloud
Messages: 1
Registered: December 2006
Location: San francisco
Junior Member
Hi,

I am trying to write a SQL statement that will check for me the data type for example of a zip code.
I do check the lenght of the field, and it will help a lot however now i am trying to get all the bad data such that have characters instead of numbers in the zip code.

wondering if anyone would have an idea ?
thanks a lot in advance
Philippe
Re: CHECK data type in SQL [message #209985 is a reply to message #209983] Mon, 18 December 2006 19:13 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>wondering if anyone would have an idea ?
Define it to be NUMBER(5) & have Oracle maintain data integrity.
Re: CHECK data type in SQL [message #210007 is a reply to message #209985] Mon, 18 December 2006 22:32 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi anacedent,

why he has to wonder about the orafaq members knowledge? Strange ...

Bye
Ashu
Previous Topic: Taking so much time when quering
Next Topic: compare
Goto Forum:
  


Current Time: Mon Dec 05 19:20:04 CST 2016

Total time taken to generate the page: 0.16108 seconds