BCA Syllabus – DBMS Lab (Oracle)

4.5 DBMS Lab (Oracle)

Second Year          Part III Group A              Fourth Semester                Subject Code:   

PL / SQL

1.      Program using conditional control, iterative controls and sequential controls.

2.      Programs using exception handling.

3.      Programs using explicit cursors and implicit cursors.

4.      Programs using PL / SQL tables and records.

5.      Programs using database triggers.

6.      Programs to design procedures using in, out, inout parameter.

7.      Program to design procedures using functions.

8.      Program to design procedures using packages.

FORMS & REPORT WRITER

1.      Inventory Control.

2.      Banking.

3.      Students mark list.

4.      Library maintenance.

5.      Payroll.

6.      Invoice.

7.      Railway Reservation.

8.      College Admission.