DECLARE
myvar VARCHAR2 (30) := 'abc123';
mynum PLS_INTEGER;
BEGIN
BEGIN
mynum := myvar;
EXCEPTION
WHEN VALUE_ERROR
THEN
DBMS_OUTPUT.put_line (' myvar is not numeric: ' || myvar);
END;
END;
Mike
On Thu, May 5, 2011 at 11:57 AM, swaroop gowda <[email protected]>wrote:
> Hi All,
>
> Any one knows how to check the string has numeric?
>
> Please let me know.
>
> --
> Thanks & Regards
> Swaroop Thailuru Swamy
> Ph: 713-392-1571
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
