d

DECLARE
 no NUMBER := 0;
BEGIN
WHILE no < 10 LOOP
 no := no + 1;
 END LOOP;
 DBMS_OUTPUT.PUT_LINE('Sum :' || no);
END;

OUTPUT  : 
Statement processed.
Sum :10

FOR LOOP : 

BEGIN
FOR no IN 1 .. 5 LOOP
 DBMS_OUTPUT.PUT_LINE('Iteration : ' || no);
 END LOOP;
END;

OUTPUT : 
Statement processed.
Iteration : 1
Iteration : 2
Iteration : 3
Iteration : 4
Iteration : 5

7B . Exception Handling : 

create table customers(
    id int,
    name varchar(20),
    address varchar(20)
);

insert into customers values(1,'suresh','hyderabad');
insert into customers values(2,'Naresh','banglore');
insert into customers values(3,'Ramesh','chennai');
insert into customers values(4,'Pavitra','hyderabad');
insert into customers values(5,'Jessy','delhi');

DECLARE
 c_id customers.id%type := 8;
 c_name customers.name%type;
 c_addr customers.address%type;
BEGIN
 SELECT name, address INTO c_name, c_addr
 FROM customers
 WHERE id = c_id;
 DBMS_OUTPUT.PUT_LINE ('Name: '|| c_name);
 DBMS_OUTPUT.PUT_LINE ('Address: ' || c_addr);
EXCEPTION
 WHEN no_data_found THEN
 dbms_output.put_line('No such customer!');
 WHEN others THEN
 dbms_output.put_line('Error!');
END;


Output : 

Statement processed.
No such customer!

Experiment 7C : 

DECLARE
  c_id customers.id%type := 2;
  c_name customers.name%type;
  c_addr customers.address%type;
  -- user-defined exception
  ex_invalid_id EXCEPTION;
BEGIN

  IF c_id <= 0 THEN
    RAISE ex_invalid_id;
  ELSE
    SELECT name, address INTO c_name, c_addr
    FROM customers
    WHERE id = c_id;
    DBMS_OUTPUT.PUT_LINE('Name: ' || c_name);
    DBMS_OUTPUT.PUT_LINE('Address: ' || c_addr);
  END IF;
EXCEPTION
  WHEN ex_invalid_id THEN
    dbms_output.put_line('ID must be greater than zero!');
  WHEN no_data_found THEN
    dbms_output.put_line('No such customer!');
  WHEN others THEN
    dbms_output.put_line('Error!');
END;


output : 

Statement processed.
Name: Naresh
Address: banglore