Assignment 5

ASSIGNMENT 5 SOLUTION WITH SOURCE CODE

Cursors

Contents:

  1. Set A
  2. Set B

Set A

Q 1. Write a cursor which will display list of projects started in month of “January” 2020.

 Download code        Source code 

Q 2.Write a cursor which displays the details of project having budget more than 100000 from ‘Computer Science Department’.

 Download code        Source code 

Q 3. Write a cursor which will display status wise project details of each department.

 Download code        Source code 

Set B

Q 1. Write a cursor which will display Gym details having charges more than 5000 from ‘Pune’ city.

 Download code        Source code 

Q 2. Write a cursor which will display city wise Gym details.

 Download code        Source code 

Q 3. Write a cursor which will display gym wise member details.(Use Parametrized Cursor)

 Download code        Source code