SQL> begin

2 dbms_output.put_line('Welcome to PL/SQL');
3 end;
4
5
6
7
8
9
10 /

PL/SQL procedure successfully completed.

SQL> declare
2 num1 number := 100;
3 num2 number := 200;
4 begin
5 dbms_output.put_line('Division: ' || num2/num1);
6 end;
7 /

PL/SQL procedure successfully completed.

SQL> set serveroutput on;

SQL> /
Division: 2

PL/SQL procedure successfully completed.

SQL> declare
2 message varchar2(50);
3 begin
4 message:='Welcome to PL/SQL';
5 dbms_output.put_line(message);
6 /*variable declaration done in block 2*/
7 end;
8 /
Welcome to PL/SQL

PL/SQL procedure successfully completed.

SQL> declare
2 no1 number := &no1;
3 no2 number := &no2;
4 begin
5 dbms_output.put_line('Division of number is: ' || no1/no2);
6 end;
7 /
Enter value for no1: 200
old 2: no1 number := &no1;
new 2: no1 number := 200;
Enter value for no2: 100
old 3: no2 number := &no2;
new 3: no2 number := 100;
Division of number is: 2

PL/SQL procedure successfully completed.

SQL> /
Enter value for no1: 100
old 2: no1 number := &no1;
new 2: no1 number := 100;
Enter value for no2: 0
old 3: no2 number := &no2;
new 3: no2 number := 0;
declare
*
ERROR at line 1:
ORA-01476: divisor is equal to zero
ORA-06512: at line 5

SQL> declare
2 no1 number := &no1;
3 no2 number := &no2;
4 begin
5 dbms_ouput.put_line('Division of Number is: ' || no1/no2);
6 exception
7 when zero_divide then
8 /*zero_divide is pre-defined function for generating error*/
9 dbms_output.put_line('Number 2 cannot be ZERO');
10 end;
11 /
Enter value for no1: 100
old 2: no1 number := &no1;
new 2: no1 number := 100;
Enter value for no2: 0
old 3: no2 number := &no2;
new 3: no2 number := 0;
dbms_ouput.put_line('Division of Number is: ' || no1/no2);
*
ERROR at line 5:
ORA-06550: line 5, column 1:
PLS-00201: identifier 'DBMS_OUPUT.PUT_LINE' must be declared
ORA-06550: line 5, column 1:
PL/SQL: Statement ignored

SQL> declare
2 no1 number := &no1;
3 no2 number := &no2;
4 begin
5 dbms_output.put_line('Division of number is: ' || no1/no2);
6 exception
7 when zero_divide then
8 dbms_output.put_line('Number 2 cannot be ZERO');
9 end;
10 /
Enter value for no1: 100
old 2: no1 number := &no1;
new 2: no1 number := 100;
Enter value for no2: 0
old 3: no2 number := &no2;
new 3: no2 number := 0;
Number 2 cannot be ZERO

PL/SQL procedure successfully completed.

SQL> declare
2 vename varchar(10);
3 100
4 /
100
*
ERROR at line 3:
ORA-06550: line 3, column 1:
PLS-00103: Encountered the symbol "100" when expecting one of the following:
begin function pragma procedure subtype type <an identifier>
<a double-quoted delimited-identifier> current cursor delete
exists prior

SQL> declare
2 vename varchar2(10);
3 vcity varchar2(10);
4 vgender char;
5 begin
6 select ename, city, gender into vename, vcity, vgender from employee
7 where eno = &eno;
8 dbms_output.put_line('Employee Name is: '||vename);
9 dbms_output.put_line('Employee City is: '||vcity);
10 dbms_output.put_line('Employee gender is: '||vgender);
11 end;
12 /
Enter value for eno: 110
old 7: where eno = &eno;
new 7: where eno = 110;
Employee Name is: Pooja
Employee City is: Mumbai
Employee gender is: F

PL/SQL procedure successfully completed.

SQL> declare
2 vename employee.ename%type;
3
4 begin
5 select ename into vename from employee where eno = &eno;
6 dbms_output.put_line('Employee Name is: ' || vename);
7 end;
8 /
Enter value for eno: 110
old 5: select ename into vename from employee where eno = &eno;
new 5: select ename into vename from employee where eno = 110;
Employee Name is: Pooja

PL/SQL procedure successfully completed.

SQL> declare
2 vename employee.ename%type;
3 vcity employee.city%type;
4 vgender employee.gender%type;
5 begin
6 select ename, city, gender into vename, vcity, vgender, from employee
7 where eno = &eno;
8 dbms_output.put_line('Employee Name is: '||vename);
9 dbms_output.put_line('Employee City is: '||vcity);
10 dbms_output.put_line('Employee Gender is:
 11 /
Enter value for eno: 110
old 7: where eno = &eno;
new 7: where eno = 110;
ERROR:
ORA-01756: quoted string not properly terminated

SQL> declare
2 vename employee.ename%type;
3 vcity employee.city%type;
4 vgender employee.gender%type;
5 begin
6 select ename, city, gender into vename, vcity, vgender, from employee
7 where eno = &eno;
8 dbms_output.put_line('Employee Name is: '||vename);
9 dbms_output.put_line('Employee City is: '||vcity);
10 dbms_output.put_line('Employee Gender is: '||vgender);
11 end;
12 /
Enter value for eno: 110
old 7: where eno = &eno;
new 7: where eno = 110;
select ename, city, gender into vename, vcity, vgender, from employee
*
ERROR at line 6:
ORA-06550: line 6, column 61:
PL/SQL: ORA-00936: missing expression
ORA-06550: line 6, column 5:
PL/SQL: SQL Statement ignored

SQL> declare
2 vename employee.ename%type;
3 vcity employee.city%type;
4 vgender employee.gender%type;
5 begin
6 select ename, city, gender into vename, vcity, vgender from employee
7 where eno = &no;
8 dbms_output.put_line('Employee Name is: '||vename);
9 dbms_output.put_line('Employee City is: '||vcity);
10 dbms_output.put_line('Employee Gender is: '||vgender);
11 end;
12 /
Enter value for no: 110
old 7: where eno = &no;
new 7: where eno = 110;
Employee Name is: Pooja
Employee City is: Mumbai
Employee Gender is: F

PL/SQL procedure successfully completed.

SQL> declare
2 v employee%rowtype;
3 begin
4 select * from employee where eno = &eno;
5 dbms_output.put_line('Employee Name is: ' || v.ename);
6 dbms_output.put_line('Employee City is: '||v.city);
 7 dbms_output.put_line('Employee Gender is: '||v.gender);
8 end;
9 /
Enter value for eno: 110
old 4: select * from employee where eno = &eno;
new 4: select * from employee where eno = 110;
select * from employee where eno = 110;
*
ERROR at line 4:
ORA-06550: line 4, column 1:
PLS-00428: an INTO clause is expected in this SELECT statement

SQL> declare
2 v employee%rowtype;
3 begin
4 select * into v from employee where eno = &eno;
5 dbms_output.put_line('Employee Name is: '||v.ename);
6 dbms_output.put_line('Employee Gender is: '||v.gender);
7 dbms_output.put_line('Employee City is: '||v.city);
8 end;
9 /
Enter value for eno: 110
old 4: select * into v from employee where eno = &eno;
new 4: select * into v from employee where eno = 110;
Employee Name is: Pooja
Employee Gender is: F
Employee City is: Mumbai

PL/SQL procedure successfully completed.

SQL> /*wrong one*/

SQL>declare
2 v employee%rowtype;
3 begin
4 select * into v from employee where eno = &eno;
5 dbms_output.put_line('Employee Name is: '||v);
6 end;
7 /
Enter value for eno: 110
old 4: select * into v from employee where eno = &eno;
new 4: select * into v from employee where eno = 110;
dbms_output.put_line('Employee Name is: '||v);
*
ERROR at line 5:
ORA-06550: line 5, column 22:
PLS-00306: wrong number or types of arguments in call to '||'
ORA-06550: line 5, column 1:
PL/SQL: Statement ignored

SQL> v employee%rowtype;