Archive for the ‘PL-SQL’ Category

PL-SQL (Runtime value)

Posted: February 8, 2012 in PL-SQL

Run time value

Whenever this program(query) is executed the viewer asks the user to enter a value (consider ’56’ ) it displays the result as below.

This is a basic program to accept inputs from user and display the same on the screen.

1)
declare
i int;
begin
i:=&i;
DBMS_OUTPUT.PUT_LINE(i);
end;

o/p:
enter value for i: 56