PL/SQL Excercise 1

ADAMS

Statement processed.

11 Suppliers selected

The above Example also can be written as follows:



This Example canbe witten using a cursor as well.

S1 SMITH 20 LONDON
S2 JONES 10 PARIS
S3 BLAKE 30 PARIS
S4 CLARK 20 LONDON
S5 ADAMS 30 ATHENS

Number of suppliers in LONDON = 2

S1 SMITH 20 LONDON
S4 CLARK 20 LONDON

Statement processed.