check data type of a variable

[misterimran]

Hi,

i want to check data type of a varible in Oracle/d2k.
as we check a numaric variable <is_numeric(x)> in php.

Regards,

 

[lewisp]

You will need to create your own function to do this in Oracle.

 

[taupirho]

If you can pass in the variable you want to test into a procedure as a varchar, the following code will give you some ideas.

create or replace procedure isanumber(thing_to_test IN varchar2)
as
my_num number;
BEGIN
my_num := thing_to_test;
dbms_output.put_line ('I am a number');
EXCEPTION
WHEN OTHERS
then
dbms_output.put_line ('I am NOT a number');
END;


SQL> execute isanumber('13');
I am a number

PL/SQL procedure successfully completed.

SQL>
execute isanumber('13.A');
I am NOT a number

PL/SQL procedure successfully completed.