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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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 Feb 09 09:49:46 CST 2025