Q:

Write a PL/SQL program to check whether a given number is positive, negative or zero

hamza
Save to bookmark
|
2022-05-18
|
  192 
0

Write a PL/SQL program to check whether a given number is positive, negative or zero

pl/sql,
login and add your own answer to this question

All Answers

hamza
2022-05-18
need an explanation for this answer? contact us directly to get an explanation for this answer 

DECLARE
num1 NUMBER := &get_num;
BEGIN
IF num1 < 0 THEN
DBMS_OUTPUT.PUT_LINE ('The number '||num1||' is a negative number');
ELSIF num1 = 0 THEN
DBMS_OUTPUT.PUT_LINE ('The number '||num1||' is equal to zero');
ELSE
DBMS_OUTPUT.PUT_LINE ('The number '||num1||' is a positive number');
END IF;
END;
/

Sample Output:

SQL> /
Enter value for get_num: 45
old   2: num1 NUMBER := &get_num;
new   2: num1 NUMBER := 45;
The number 45 is a positive number

PL/SQL procedure successfully completed

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions

need a help?

find thousands of online teachers now