SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to check the input is is a real number

Murali....Jan 29 2007 — edited Jan 29 2007

Hi,

I just want to check the input is not a negative number.

for example,

vNum NUMBER := -1 THEN DBMS_OUTPUT.PUT_LINE('wrong');
vNum NUMBER := 1 THEN DBMS_OUTPUT.PUT_LINE('rite');

How can i check whether the input is not a negative value?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 26 2007

Added on Jan 29 2007

2 comments

190 views