Question: I use Apex oracle SQL 1). Write a SQL query that will select the department number and department name from the dept table. You will

I use Apex oracle SQL

1). Write a SQL query that will select the department number and department name from the dept table. You will have to do a DESCRIBE on the dept table to get the actual spelling of the columns.

2. Write a SQL query that will select the employee number, employee name and job from the emp table.

3. Write a SQL query using the emp table that will return only the employees that have CLERK as their job. The columns to be included in the select are: the employee number, employee name and job.

4. Write SQL query using the emp table that shows only the employees that have a salary greater than 1250. The columns to be included in the select are: the employee number, employee name, job and salary.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!