pradeepchegur / Cloth_Showroom_SQL Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

This SQL file consists of cloth showroom management along with queries.

0 stars 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
CLOTH_SHOWROOM.sql		CLOTH_SHOWROOM.sql
README.md		README.md

Repository files navigation

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).

About

This SQL file consists of cloth showroom management along with queries.

sql database functions plsql operations procedures triggers tables cursors clothing-store sqlqueries

Report repository

Releases

No releases published

Packages

No packages published