OraFAQ Forum: SQL & PL/SQL » CHECK data type in SQL

Home » SQL & PL/SQL » SQL & PL/SQL » CHECK data type in SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CHECK data type in SQL [message #209983]

Mon, 18 December 2006 18:44

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

Report message to a moderator

Re: CHECK data type in SQL [message #209985 is a reply to message #209983]

Mon, 18 December 2006 19:13

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: CHECK data type in SQL [message #210007 is a reply to message #209985]

Mon, 18 December 2006 22:32

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

Report message to a moderator

Previous Topic:	Taking so much time when quering
Next Topic:	compare

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 13 00:14:49 CST 2024