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 <swaroop.t...@gmail.com>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 Oracle-PLSQL@googlegroups.com
> To unsubscribe from this group, send email to
> oracle-plsql-unsubscr...@googlegroups.com
> 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 Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
