-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|