Description of if statement in PL/SQL in Oracle

The following is a detailed analysis of the if statement in Oracle PLSQL. For more information, see copy the code below: * If statement: determine the number entered by the user. * Setserveroutputon -- input acceptnumprompt on the receiving keyboard. Enter a number:; declare -- enter the number entered on the screen.

The following is a detailed analysis of the if statement in PL/SQL in Oracle. For more information, see the following code:/* If statement: determines the number entered by the user. */Set serveroutput on -- receive keyboard input accept num prompt 'enter a number:'; declare -- set the number entered on the screen

The following is a detailed analysis of the if statement in PL/SQL in Oracle.

The Code is as follows:

/*
If statement:
Determines the number entered by the user.
*/
Set serveroutput on

-- Receive keyboard input
Accept num prompt 'enter a number :';

Declare
-- Pay the number entered on the screen to the variable
Pnum number: = #
Begin
If pnum = 0 then dbms_output.put_line ('your input is 0 ');
End if;

If pnum = 1 then dbms_output.put_line ('What you entered is 1 ');
End if;

If pnum = 2 then dbms_output.put_line ('your input is 2 ');
End if;
End;
/