clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 809161 fiddles created (9808 in the last week).

DECLARE value VARCHAR(100) := 'a'; BEGIN IF (VALIDATE_CONVERSION(value AS NUMBER) = 1) THEN DBMS_OUTPUT.PUT_LINE(value || ' is a number'); ELSE DBMS_OUTPUT.PUT_LINE(value || ' is not a number'); END IF; END; //
1 rows affected dbms_output: a is not a number
 hidden batch(es)