Home » SQL & PL/SQL » SQL & PL/SQL » How Chek numeric value true / false in sql (Oracle)
icon11.gif  How Chek numeric value true / false in sql [message #360282] Thu, 20 November 2008 04:54 Go to next message
surit.patel
Messages: 5
Registered: November 2008
Location: Mumbai
Junior Member

Hi Dear,


How can find out in SQL numeric value true/false.

Pls. Help



Re: How Chek numeric value true / false in sql [message #360284 is a reply to message #360282] Thu, 20 November 2008 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
true/false does not exist in Oracle SQL.

Regards
Michel
Re: How Chek numeric value true / false in sql [message #360301 is a reply to message #360284] Thu, 20 November 2008 06:08 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Performa a to_number on it.
If it raises an exception, it wasn't a valid number.

To do this in SQL, you'll need to create a function to perform the above logic, and pass back a Y/N, or 1/0/
Previous Topic: Finding non-numeric values
Next Topic: Identifying Control Characters as well as viewing them.. (merged)
Goto Forum:
  


Current Time: Sun Dec 04 20:51:05 CST 2016

Total time taken to generate the page: 0.10097 seconds