Friday, September 18, 2020

RDBMS PLSQL Program 2 Basic Input Output

 SET SERVEROUTPUT ON 

DECLARE

    i number(10,2);

    str1 varchar(20);

BEGIN

i := &i;

if i = 2 then 

DBMS_OUTPUT.PUT_LINE('Input rejected');

else

str1 := '&str1'; 

DBMS_OUTPUT.PUT_LINE('Value of str =' || str1 );

end if;

END;

/

No comments:

Post a Comment

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