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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s