Scribd
Upload
12 views14 pages

dbms lab manual mtech cse 2025

The document is a laboratory record for the Database Programming course submitted by Gurri Suvidha Reddy as part of the M.Tech program at Jawaharlal Nehru Technological University, Hyderabad. It includes a certificate of authenticity and a list of experiments that involve writing PL/SQL programs for various database operations. The experiments cover topics such as inserting data, using cursors, handling exceptions, and creating procedures and triggers.

Uploaded by

brigcse05
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views14 pages

dbms lab manual mtech cse 2025

The document is a laboratory record for the Database Programming course submitted by Gurri Suvidha Reddy as part of the M.Tech program at Jawaharlal Nehru Technological University, Hyderabad. It includes a certificate of authenticity and a list of experiments that involve writing PL/SQL programs for various database operations. The experiments cover topics such as inserting data, using cursors, handling exceptions, and creating procedures and triggers.

Uploaded by

brigcse05
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 14

lOMoARcPSD|29537650

Database Programming Laboratory Record

CSE (Software Engineering) (Jawaharlal Nehru Technological University, Hyderabad)

Scan to open on Studocu

Studocu is not sponsored or endorsed by any college or university


Downloaded by K brillent (brigcse05@gmail.com)
lOMoARcPSD|29537650

DATABASE PROGRAMMING LABORATORY RECORD


FOR

M.TECH (SOFTWARE PROGRAMMING)

I YEAR, I SEMESTER

Submitted by

GURRI SUVIDHA REDDY

24011D2502

DEPARTMENT OF INFORMATION TECHNOLOGY


UNIVERSITY COLLEGE OF ENGINEERING, SCIENCE AND TECHNOLOGY HYDERABAD

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

TELANGANA

(2024–26)

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

UNIVERSITY COLLEGE OF ENGINEERING, SCIENCE AND TECHNOLOGY HYDERABAD

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY HYDERABAD

Kukatpally, Hyderabad – 500085

CERTIFICATE

This is to certify that the record entitled “DATABASE PROGRAMMING LAB” is being
submitted by GURRI SUVIDHA REDDY, Reg. No. 24011D2502 in partial fulfillment of
the requirements for the award of the degree of MASTER OF TECHNOLOGY in the
DEPARTMENT OF INFORMATION TECHNOLOGY, UNIVERSITY COLLEGE OF
ENGINEERING, SCIENCE AND TECHNOLOGY, HYDERABAD, JAWAHARLAL
NEHRU TECHNOLOGICAL UNIVERSITY HYDERBAD is a record of bona-fide work
carried out by her under my guidance and supervision.

The results embodied in this record have not been submitted to any other university or
institution for the award of any degree or diploma.

INTERNAL EXAMINER EXTERNAL EXAMINER

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

DATABASE PROGRAMMING LABORATORY RECORD

LIST OF EXPERIMENTS

S. No. NAME OF THE EXPERIMENT PAGE NO.

1 Write a PL/SQL program using FOR loop to insert 4

ten rows into a database table.

2 Given the table Employee(EmpNo, Name, Salary, 5

Designation, DeptID), write a cursor to select the

five highest paid employees from the table.

3 Given an integer i, write a PL/SQL procedure to 7

insert the tuple(i, ‘xxx’) into a given relation.

4 Write a PL/SQL program to demonstrate 8

Exceptions.

5 Write a PL/SQL program to demonstrate Cursors. 9

6 Write a PL/SQL program to demonstrate Functions. 10

7 Write a PL/SQL program to demonstrate Packages. 11

8 Write a PL/SQL queries to create Procedures. 12

9 Write a PL/SQL queries to create Triggers. 13

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

1. Write a PL/SQL program using FOR loop to insert ten rows into database table.

PROGRAM:

OUTPUT:

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

2. Given the table Employee(EmpNo, Name, Salary, Designation, DeptID), write a


cursor to select the five highest paid employees from the table.

PROGRAM:

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

OUTPUT:

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

3. Given an integer i, write a PL/SQL procedure to insert the tuple(i, ‘xxx’) into a given
relation.

PROGRAM:

OUTPUT:

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

4. Write a PL/SQL program to demonstrate Exceptions.

PROGRAM:

OUTPUT:

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

5. Write a PL/SQL program to demonstrate Cursors.

PROGRAM:

OUTPUT:

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

6. Write a PL/SQL program to demonstrate Functions.

PROGRAM:

OUTPUT:

10

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

7. Write a PL/SQL program to demonstrate Packages.

PROGRAM:

OUTPUT:

11

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

8. Write a PL/SQL queries to create Procedures.

PROGRAM:

OUTPUT:

12

Downloaded by K brillent (brigcse05@gmail.com)


lOMoARcPSD|29537650

9. Write a PL/SQL queries to create Triggers.

PROGRAM:

OUTPUT:

13

Downloaded by K brillent (brigcse05@gmail.com)

You might also like