Hello Everyone,
DB: 10g
Just wondering, if there is a way to check if data from a varchar2 column contains a positive interger. Example -
tab1
col1
1
3
1
4
5
2.3
bye
So, my code should accept all the values except 2.3 and bye. Once it get bye or 2.3, it should throw an
exception.
How to do it? Please advice.
Thanks.