SET VERIFY OFF
SET SERVEROUTPUT ON
DECLARE
v_user_input NUMBER := &user_input_number;
BEGIN
IF v_user_input < 0 THEN
DBMS_OUTPUT.PUT_LINE ( v_user_input || ' is a negative number' );
ELSIF v_user_input = 0 THEN
DBMS_OUTPUT.PUT_LINE ( v_user_input || ' is equal to Zero' );
ELSE
DBMS_OUTPUT.PUT_LINE ( v_user_input || ' is a positive number' );
END IF;
END;
/
Enter value for user_input_number: -24
-24 is a negative number
PL/SQL procedure successfully completed.
Subscribe to:
Post Comments (Atom)
External Table
Oracle External Table External tables are defined as tables that do not resides in the database allows you to access data that is stor...
-
Table clustering is an optional technique of storing data. In table clustering, rows from one or more tables those are associated with ea...
-
Oracle PL/SQL block accepts user input information with the help of substitution variable. Substitute variable can not be used to output va...
-
Finally continue statement added to oracle 11g PL/SQL language. It signals an immediate end to a loop iteration and return to first statemen...
No comments:
Post a Comment