Friday, September 18, 2020

RDBMS PLSQL Program 3 If statement

 set serveroutput on

declare

i number(10,2);

begin

i := &i;

if i=1 then

dbms_output.put_line('black tea');

elsif i=2 then

dbms_output.put_line('green tea');

else

dbms_output.put_line('pink tea');

end if;

end;

/

No comments:

Post a Comment

Thanks for showing your interest
I will shortly get back to you