BDC_LAB#4.md

Databases Laboratory Work #4

Query editor for T-SQL and PL/SQL:

Prerequisites:

• Microsoft SQL Server 2012
• Oracle 11g/12c

Objectives:

• Elements of T-SQL and PL SQL/language

General Requirements:

Laboratory work is considered as successfully passed after fulfilling the following steps:

1. During laboratory work should be completed 30% of requirements in order to get high mark (9-10)
2. The laboratory requirement should be accomplished on MSSQL and Oracle
3. You must elaborate a Report which will contain your work-flow and your conclusions. - Laboratory work paper Dead Line is due to next laboratory, and the report must be sent to my email in an appropriate format (such as PDF format). - Laboratory work paper must have all the mentioned execises - Laboratory work paper must have a conclusion of: 0.5 pages
4. You must pass the quiz

Laboratory Requirements:

1. Laboratory work # 4 requirements cap 4
2. Tasks must be fulfilled on both MSSQL and Oracle language and screens attached for both of them also.
3. From the list of queries, choose 5 randomly (different difficulty)

References:

• PL/SQL Language Elements