MAHARASHTRA STATE OF TECHNICAL EDUCATION, MUMBAI
GOVERNMENT POLYTECHNIC DHARASHIV
CERTIFICATE
This is to certify that the, micro project entitled –
“…………………………………………………………………………………………………………………………………………..”
Submitted by
Mr/Ms…………………………………………………………………………………………………………………………………
Roll no……………………. of ………………………………. Semester of diploma in …………………………………
…………………………………………. has completed project work satisfactory in the Database
management system (22319) for the academic year 2023-2024 as prescribed in the
curriculum.
Place:-………………………. Enrolment no:-……………..
Date:-………………………… Exam seat no:-……………….
Guidance by Head of department Principal
1
MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION MUMBAI
Government Polytechnic, Dharashiv
CERTIFICATE
This is to certify that the microproject titled –
Submitted by Roll no 28, 29, 30 of CO3I of third semester of Diploma in computer
engineering has completed Micro-project work satisfactory in the database management
system (22319) for the academic year 2023- 2024 as prescribed in the curriculum.
Place: …………………………. Date…………………………….
Roll no Name of student Enrolment no Seat no
28. Kshirsagar Samarth Dattatray 2201180233 387253
29. Masiha Silviya Santosh 2201180234 387254
30. Kawade Priya Shankar 2201180235 387255
Subject teacher Head of department Principal
2
ACKNOWLEDGEMENT
It gives us a great sense of pleasure to present the report of the Project Work. We would like
to express our special thanks of gratitude to our Project Guide Mr. S. D. Pore sir for guiding
and correcting various mistakes of us with attention and care. We also do not like to miss the
opportunity to acknowledge the contribution of all faculty members of the department for
their kind assistance and cooperation during the development of our project. Last but not the
least, we acknowledge our friends for their contribution in the completion of the project.
3
ACTION PLAN
Sr no. Details of activity Plan start date Plan finish date Responsible team members
1 Topics given by Samarth Dattatray Kshirsagar
subject teacher & Silviya Santosh Masiha
discussion on given Kawade Priya Shankar
topic with member
2 Collection of Samarth Dattatray Kshirsagar
information related to Silviya Santosh Masiha
the topic Kawade Priya Shankar
3 Planning of project Samarth Dattatray Kshirsagar
Silviya Santosh Masiha
Kawade Priya Shankar
4 Distribution of roles Samarth Dattatray Kshirsagar
and Silviya Santosh Masiha
responsibilities to Kawade Priya Shankar
each member
5 Design of micro- Samarth Dattatray Kshirsagar
project Silviya Santosh Masiha
Kawade Priya Shankar
6 implementation Samarth Dattatray Kshirsagar
Silviya Santosh Masiha
Kawade Priya Shankar
7 Report preparation Samarth Dattatray Kshirsagar
Silviya Santosh Masiha
Kawade Priya Shankar
8 Submission of micro- Samarth Dattatray Kshirsagar
project Silviya Santosh Masiha
Kawade Priya Shankar
4
INDEX
Sr no Content Page no.
1. Introduction 6
2. Program code 7
3. Output 8
4. Conclusion
5. Reference
5
INTRODUCTION
PL / SQL INTRODUCTION :-
PL/SQL is a block structured language that enables developers to combine the power of
SQL with procedural statements. All the statements of a block are passed to oracle engine
all at once which increases processing speed and decreases the traffic.
PL/SQL stands for Procedural Language extensions to the Structured Query Language.
PL/SQL is a combination of SQL along with the procedural features of programming
languages.
Oracle uses a PL/SQL engine to processes the PL/SQL statements.
PL/SQL includes procedural language elements like conditions and loops. It allows
declaration of constants and variables, procedures and functions, types and variable of
those types and triggers.
We used ‘like’ operator which is pattern matching operator used for searching specified
pattern in column.
Percent sign ( % ) represents zero, one or multiple characters.
Underscore sign ( _ ) represents single character.
Structure of PL/SQL Block:
PL/SQL extends SQL by adding constructs found in procedural languages, resulting in a
structural language that is more powerful than SQL. The basic unit in PL/SQL is a block. All
PL/SQL programs are made up of blocks, which can be nested within each other.
6
PROGRAM CODE
Creating employee table:
Create table employee
( E_id number not null ,
E_name varchar2(50) ,
E_sal number ,
E_dept varchar2(50) ,
E_address varchar2(50) );
Inserting data in employee table:
insert into employee values(101,'Namrata',56000,'Software','Pune');
insert into employee values (102, 'Kriti',30000, 'Sales', 'Nagpur');
insert into employee values (103, 'Ashish',55000, 'Testing' ,'Bangalore');
insert into employee values (104, 'Sanjana',33000,'Marketing','Solapur');
insert into employee values (105, ' Aakanksha ',30000, 'Administration', 'Latur');
insert into employee values (106,'Utkarsh',43000, 'Production', 'Hyderabad');
insert into employee values (107, 'Radhika',67000, 'software', 'Mumbai');
insert into employee values (108, 'Kartik',50000, 'IT', 'Pune');
PL /SQL program to find names having second letter ‘a’:-
DECLARE
E_name VARCHAR2(50);
BEGIN
SELECT Word INTO E_name FROM Words WHERE Word LIKE '_A%';
DBMS_OUTPUT.PUT_LINE('Word with A at the second position: ' || E_name); END;
7
OUTPUT
Employee table :-
Employee table after applying query:-
E_id E_name E_salary E_dept E_salary
101 Namarta 56000 Software Pune
104 Sanjana 33000 Marketing Solapur
105 Aakanksha 30000 Administration Latur
107 Radhika 67000 Software Mumbai
108 Karthik 50000 IT Pune
8
CONCLUSION
In conclusion we came to know that the PL/ SQL stored procedures are a single unit that
contains the business logic written inside it and which can also involve multiple data
manipulation and retrieval of database values in its statements. And we also learned to use
pattern matching operator ‘like’ in PL/SQL programs.
9
REFERENCE
Websites like
www.geeksforgeeks.com
www.wikipedia.com
www.google.com
Textbook of database management system.
10
