Example of Simple PL/SQL Block

1. Write a PL-SQL Block which takes name as input and then display that name.

Declare

Name Char(100);

Begin

                Name:='&Name';

                dbms_output.put_line('Name='||Name);

End;

Output:

        Enter value for name: Ankur N Shah

old   4: Name:='&Name';

new   4: Name:='Ankur N Shah';

Name=Ankur N Shah

PL/SQL procedure successfully completed.