JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

DATABASE PROGRAMMING WITH PL/SQL LAB

M.Tech I Year I Semester (R22)

Course Objectives:

  • 1. Knowledge on significance of SQL fundamentals.
  • 2. Evaluate functions and triggers of PL/SQL
  • 3. Knowledge on control structures, packages in PL/SQL and its applications

Course Outcomes:

  • 1. Understand importance of PL/SQL basics
  • 2. Implement functions and procedures using PL/SQL
  • 3. Understand the importance of triggers in database

List of Experiments:

  • 1. Write a Pl/SQL program using FOR loop to insert ten rows into a database table.
  • 2. Given the table EMPLOYEE (EmpNo, Name, Salary, Designation, DeptID), write a cursor to select the five highest paid employees from the table.
  • 3. Illustrate how you can embed PL/SQL in a high-level host language such as C/Java And demonstrates how a banking debit transaction might be done.
  • 4. Given an integer i, write a PL/SQL procedure to insert the tuple (i, 'xxx') into a given relation.
  • 5. Write a PL/SQL program to demonstrate Exceptions.
  • 6. Write a PL/SQL program to demonstrate Cursors.
  • 7. Write a PL/SQL program to demonstrate Functions.
  • 8. Write a PL/SQL program to demonstrate Packages.
  • 9. Write PL/SQL queries to create Procedures.
  • 10. Write PL/SQL queries to create Triggers.

Loading Question Papers

Fetching data from database...