I am trying to check the datatype of a variable, it is usually passed in a Varchar2, buthow do I check (if its a Number OR Date Or String).
But I want to validate the content of the variable (IS Date, IS Number or IS String -- returning Boolean) before moving next to the next logic.

This how is done in VB & SQL Server

IF IsNumber(v_var) <> 1 THEN
-- True
Do something
Else
--False
Do something else
End IF

OR
IF IsDate(v_var) <> 1 THEN
-- True
Do something
Else
--False
Do something else
End IF



How can I do this validation check in Oracle PL/SQL?

Suggestions?