Skip to content

Latest commit

 

History

History
11 lines (9 loc) · 764 Bytes

README.md

File metadata and controls

11 lines (9 loc) · 764 Bytes
Raw

Cloth_Showroom_SQL

This SQL file consists of cloth showroom management details.

This SQL file contains creation of tables and insertion of details into the tables.

It consists of 11 tables like owner, cloth, employee, etc.

Also it have 40 queries and retrival code for those queries.

Queries consists of 8 operations like set theory operations, Logical operations, Equi join operations, etc.

5 queries are present in each operation and commented clearly in SQL file.

After commit command, the file also has PL/SQL programs which includes Functions, Procedures, Triggers and Cursors respectively.

These PL/SQL programs can be run in command prompt not in SQl file. (Cut and paste these programs in command prompt serially).