Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Boolean Function in SQL

Boolean Function in SQL

From: <pmohanan_at_my-deja.com>
Date: Tue, 03 Oct 2000 20:35:27 GMT
Message-ID: <8rdfue$db2$1@nnrp1.deja.com> 






Hi..All,




     Is there any function in Oracle which returns 1/TRUE or 0/FALSE
depending on the condition. I am trying to check whether the value of a
particluar column is numeric.



When i use to_number(col_name,'99999999') it bombs when it received a
char_value.



Is there any function like isnumber()? or ischar() in oracle.



The alternative i found was


substr(col_name,1,1) in ('0','1',.....'9')



Any other alternatives?



Regards,



Praveen




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Tue Oct 03 2000 - 15:35:27 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US