# data[].attributes.body
project#2:

PL/SQL Exercise 1 – PL/SQL block, cursors

1. Write a PL/SQL block which includes a procedure get_cleaner_details which accepts a cleaner number and returns the cleaners name and salary. The main block should call the procedure with cleaner number ‘113’ and output this cleaner’s details including the salary which has been increased by 10%. Run this block from Oracle 11g Express Edition. Post the screen shots in Padlet: https://padlet.com/jen_almarasy/ADBMS_SEP2016B

2. Now rewrite question 1) so all cleaners in the Cleaner tab.le have their information displayed with their salaries increased by 10%. The main block now includes a cursor ‘cleanercursor’ which allows the processing of multiple rows returned by a query. Run this block from Oracle 11g Express Edition. https://padlet.com/jen_almarasy/ADBMS_SEP2016B

# data[].attributes.body
Nice meeting you today

# data[].attributes.headline
Hi...welcome to your ADBMS course online! 

# data[].attributes.subject
Hi...welcome to your ADBMS course online! 

# data[].attributes.body
I have started my teaching career when I was 20 years old and I have been teaching for 16 years now. Well, you don't need to guess my age but look forward to the things that you will learn from the course and other students.