PNAME          STOCK        PID DOP                                             
--------- ---------- ---------- ---------                                       
pen               80         12 12-JAN-18                                       
marker            67         34 20-JAN-18                                       
book              34         56 16-JAN-18                                       
pen               54         78 04-FEB-18                                       

SQL> begin
  2  dbms_output.put_line('Hi Team');
  3  end;
  4  /
Hi Team                                                                         

PL/SQL procedure successfully completed. 


SQL> declare
  2  i number:=4;
  3  begin
  4  dbms_output.put_line('The value is:'||i);
  5  end;
  6  /
The value is:4                                                                  

PL/SQL procedure successfully completed.

SQL> declare
  2  i number:=4;
  3  j number:=5;
  4  k number;
  5  begin
  6  k:=i+j;
  7  dbms_output.put_line('Addition is:'||k);
  8  end;
  9  /
Addition is:9                                                                   

PL/SQL procedure successfully completed.


SQL> declare
  2  i number:=4;
  3  j number:=5;
  4  k number;
  5  sName varchar2(15):='manju';
  6  begin
  7  k:=i+j;
  8  dbms_output.put_line('Addition is:'||k);
  9  dbms_output.put_line('sName is:'||sName);
 10  end;
 11  /
Addition is:9                                                                   
sName is:manju                                                                  

PL/SQL procedure successfully completed.


SQL> declare
  2  i number:=&i;
  3  j number:=&j;
  4  k number;
  5  begin
  6  k:=i+j;
  7  dbms_output.put_line('Addition is:'||k);
  8  end;
  9  /
Enter value for i: 6
old   2: i number:=&i;
new   2: i number:=6;
Enter value for j: 4
old   3: j number:=&j;
new   3: j number:=4;
Addition is:10                                                                  

PL/SQL procedure successfully completed.


SQL> declare
  2  p number:=&p;
  3  t number:=&t;
  4  r number:=&r;
  5  si number(5,2);
  6  begin
  7  si:=(p*t*r)/100;
  8  dbms_output.put_line('simple interest is:'||si);
  9  end;
 10  /
Enter value for p: 2
old   2: p number:=&p;
new   2: p number:=2;
Enter value for t: 25
old   3: t number:=&t;
new   3: t number:=25;
Enter value for r: 2
old   4: r number:=&r;
new   4: r number:=2;
simple interest is:1                                                            

PL/SQL procedure successfully completed.

SQL> /
Enter value for p: 4
old   2: p number:=&p;
new   2: p number:=4;
Enter value for t: 56
old   3: t number:=&t;
new   3: t number:=56;
Enter value for r: 6
old   4: r number:=&r;
new   4: r number:=6;
simple interest is:13.44                                                        

PL/SQL procedure successfully completed.


SQL> declare
  2  m1 number:=&m1;
  3  m2 number:=&m2;
  4  m3 number:=&m3;
  5  t number;
  6  res number(5,2);
  7  begin
  8  t:=m1+m2+m3;
  9  res:=(m1*m2*m3)/3;
 10  dbms_output.put_line('total is:'||t);
 11  dbms_output.put_line('average is:'||res);
 12  end;
 13  /
Enter value for m1: 2
old   2: m1 number:=&m1;
new   2: m1 number:=2;
Enter value for m2: 2
old   3: m2 number:=&m2;
new   3: m2 number:=2;
Enter value for m3: 2
old   4: m3 number:=&m3;
new   4: m3 number:=2;
total is:6                                                                      
average is:2.67                                                                 

PL/SQL procedure successfully completed.

SQL> declare
  2  m1 number:=&m1;
  3  m2 number:=&m2;
  4  m3 number:=&m3;
  5  t number;
  6  res number(5,2);
  7  sName char(15):='&sName';
  8  begin
  9  t:=m1+m2+m3;
 10  res:=(m1+m2+m3)/3;
 11  dbms_output.put_line('Student name:'||sName);
 12  dbms_output.put_line('Total marks:'||t);
 13  dbms_output.put_line('Average is:'||res);
 14  end;
 15  /
Enter value for m1: 3
old   2: m1 number:=&m1;
new   2: m1 number:=3;
Enter value for m2: 3
old   3: m2 number:=&m2;
new   3: m2 number:=3;
Enter value for m3: 3
old   4: m3 number:=&m3;
new   4: m3 number:=3;
Enter value for sname: manju
old   7: sName char(15):='&sName';
new   7: sName char(15):='manju';
Student name:manju                                                              
Total marks:9                                                                   
Average is:3                                                                    

PL/SQL procedure successfully completed.

SQL> declare
  2  m1 number:=&m1;
  3  m2 number:=&m2;
  4  m3 number:=&m3;
  5  t number;
  6  res number(5,2);
  7  sName char(15):='&sName';
  8  begin
  9  t:=m1+m2+m3;
 10  res:=(m1+m2+m3)/3;
 11  dbms_output.put_line('Student name:'||sName);
 12  dbms_output.put_line('m1 marks:'||m1);
 13  dbms_output.put_line('m2 marks:'||m2);
 14  dbms_output.put_line('m3 marks:'||m3);
 15  dbms_output.put_line('Total marks:'||t);
 16  dbms_output.put_line('Average is:'||res);
 17  end;
 18  /
Enter value for m1: 90
old   2: m1 number:=&m1;
new   2: m1 number:=90;
Enter value for m2: 80
old   3: m2 number:=&m2;
new   3: m2 number:=80;
Enter value for m3: 70
old   4: m3 number:=&m3;
new   4: m3 number:=70;
Enter value for sname: manju
old   7: sName char(15):='&sName';
new   7: sName char(15):='manju';
Student name:manju                                                              
m1 marks:90                                                                     
m2 marks:80                                                                     
m3 marks:70                                                                     
Total marks:240                                                                 
Average is:80                                                                   

PL/SQL procedure successfully completed.