Oracle Database Exercises: Advanced Database (ECOM 5054) - Islamic University of Gaza, Lecture notes of Computer Science

cyber security information and detailed idea of using white hacking.

Typology: Lecture notes

2020/2021

Uploaded on 06/19/2021

mad-man
mad-man 🇵🇰

3 documents

1 / 7

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Islamic University of Gaza Advanced DataBase ECOM 5054
Faculty of Engineering Instructor: Eng. Husam Alzaq
Computer Department T.A: Eng. Doaa KH. Abu Jabal
Oracle LAB 5
Part 1
Exercise 1:
A) Write a query that displays the last name (with the first letter uppercase and all
other letters lowercase) and the length of the last name for all employees whose
name starts with the letters J, A, or M. Give each column an appropriate label.
Sort the results by the employees’ last names.
The Result:
pf3
pf4
pf5

Partial preview of the text

Download Oracle Database Exercises: Advanced Database (ECOM 5054) - Islamic University of Gaza and more Lecture notes Computer Science in PDF only on Docsity!

Faculty of Engineering Instructor: Eng. Husam Alzaq Computer Department T.A: Eng. Doaa KH. Abu Jabal

Oracle LAB 5

Part 1

Exercise 1:

A) Write a query that displays the last name (with the first letter uppercase and all

other letters lowercase) and the length of the last name for all employees whose

name starts with the letters J, A, or M. Give each column an appropriate label.

Sort the results by the employees’ last names.

Faculty of Engineering Instructor: Eng. Husam Alzaq Computer Department T.A: Eng. Doaa KH. Abu Jabal

Or:

Faculty of Engineering Instructor: Eng. Husam Alzaq Computer Department T.A: Eng. Doaa KH. Abu Jabal

Or:

Faculty of Engineering Instructor: Eng. Husam Alzaq Computer Department T.A: Eng. Doaa KH. Abu Jabal

Exercise 3:

Display each employee’s last name, hire date, and salary review date, which is the

first Monday after six months of service. Label the column REVIEW. Format the dates

to appear in the format similar to “Monday, the Thirty-First of July, 2000.”

Faculty of Engineering Instructor: Eng. Husam Alzaq Computer Department T.A: Eng. Doaa KH. Abu Jabal

Exercise 5:

Using the DECODE function, write a query that displays the grade of all employees

based on the value of the column JOB_ID, using the following data:

Job Grade

AD_PRES A

ST_MAN B

IT_PROG C

SA_REP D

ST_CLERK E

None of the above 0