PL/SQL - LEVEL1

PROCEDURES

1. Create a procedure to print the reverse of a string.

2. Create a procedure that inserts all the even numbers into one table and all the odd numbers into another table in a given range.

3. Create a table with the following fields ticket no,destination,number of persons travelling,distance,fare and insert data into the following fields : tno, destination,distance.

4. Write a procedure which calculates the fare when the destination & number of persons travelling are given.

5. Write a procedure which calculates the total sum collected today.

6. Create a procedure to calculate the avg,grade for each student & update the report table based on the marks obtained.

7. Create a procedure to cal, the area of any type of triangle.