Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: numeric check
You could also just enclose a to_date function call within an exception
block. If the coversion is successful no error is returned and the
function could return the date. In the case of an error the exception
block would be raised and NULL, a defautl value, and/or an error code
could be returned depending on application specific needs.
HTH -- Mark D Powell -- Received on Sat Mar 25 2006 - 18:32:36 CST