Prepare for your exams
Get points
Guidelines and tips
Sell on Docsity
Docsity AI

Prepare for your exams

Study with the several resources on Docsity

Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips

Sell on Docsity

Docsity AI

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents

20 Points

For each uploaded document

Answer questions

5 Points

For each given answer (max 1 per day)

All the ways to get free points

Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

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

Bahauddin Zakariya University, Multan (BZUM)Computer Science

cyber security information and detailed idea of using white hacking.

Typology: Lecture notes

2020/2021

Uploaded on 06/19/2021

mad-man 🇵🇰

3 documents

1 / 7

This page cannot be seen from the preview

Don't miss anything!

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:

Discover Lecture notes of Computer Science Bahauddin Zakariya University, Multan (BZUM)

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

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

Related documents

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!

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.

Or:

Or:

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

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