Question: JDBC JAVA!! Create a unique listing of all jobs that in department 80. Include the location of the department in the output. SQL> DESCRIBE EMPLOYEES;

JDBC JAVA!!

Create a unique listing of all jobs that in department 80. Include the location of the department in the output.

SQL> DESCRIBE EMPLOYEES;

Name Null? Type

----------------------------------------- -------- ----------------------------

EMPLOYEE_ID NOT NULL NUMBER(6)

FIRST_NAME VARCHAR2(20)

LAST_NAME NOT NULL VARCHAR2(25)

EMAIL NOT NULL VARCHAR2(25)

PHONE_NUMBER VARCHAR2(20)

HIRE_DATE NOT NULL DATE

JOB_ID NOT NULL VARCHAR2(10)

SALARY NUMBER(8,2)

COMMISSION_PCT NUMBER(2,2)

MANAGER_ID NUMBER(6)

DEPARTMENT_ID NUMBER(4)

SQL> DESCRIBE DEPARTMENTS;

Name Null? Type

----------------------------------------- -------- ----------------------------

DEPARTMENT_ID NOT NULL NUMBER(4)

DEPARTMENT_NAME NOT NULL VARCHAR2(30)

MANAGER_ID NUMBER(6)

LOCATION_ID NUMBER(4)

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!

Q:

In this lab, we will continue to explore SQL queries using HR schema. You can complete the lab using either SQL Development or SQL*Plus. For this lab exercise, you will be using HR.EMPLOYEES,...

Q:

Q.No 2. Consider the following relations: [10 Marks] EMP_NO EMP_NAME EMP_GRADE JOB_ID DEPTNO START_DATE EMP DEPTNO DEPTNAME LOC LOW_SAL HIGH_SAL DEPT Display the name concatenated with the job ID,...

Q:

Obtaining data from more than one table using various types of joins including Equijoins, Non-Equijoins, Outer Joins and Self Joins. Write a query to display the name, department number, and...

Q:

Write a query to display the name, department number, and department name for all employees. Create a unique listing of all jobs that are in department 30. Include the location of the department 30...

Q:

Create a Database using the following Script: create table PRODUCTS (ProdID integer Not null, Descrip varchar(50) Not null, Price decimal(4,2), Primary key(ProdID)); create table DEPARTMENTS (DeptNo...

Q:

DATABASE PROGRAMMING - WRITE THE SQL QUERIES FOR THE FOLLOWING QUESTIONS CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) );...

Q:

The states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation Select one: O physical data independence NOT NULL constraint O Entity...

Q:

WRITE SQL QUERIES FOR THE FOLLOWING QUESTIONS WHICH IS BASED ON EMPLOYEES TABLE Below is a sample of searched CASE statement. It finds the average salary of the employees in the Employees table,...

Q:

DEPARTMENTS DeptNo DName Location STAFF StaffID + employ, Ename Job + + Mgr CUSTOMERS CustID Name service Address City State Zip AreaCode Phone ReplD HireDate Salary Comm DeptNo manage y create...

Q:

Populate.sql: Please show with steps on cmd SQL format Rem ******** dropping tables ************* DROP TABLE SALGRADE; DROP TABLE EMPLOYEE; DROP TABLE DEPT; Rem ******** create table DEPT...

Q:

2021 2020 2019 2018 2017 Sales $ 469,167 $ 304,654 $ 238,944 $ 169,464 $ 122,800 Cost of goods sold 232,392 150,980 120,183 84,887 60,172 Accounts receivable 22,661 17,792 16,344 9,914 8,387 Compute...

Q:

Maria Corporation uses the process costing system. The following data are available from the books of Department 2. The quality control inspection takes place when the units are 75% completed and...

Q:

to whom should written management representations required by GAAS at the end if the audit be addressed

Q:

The most recent financial statements for Cornwall, Inc., are shown here: Assets, costs, and current liabilities are proportional to sales. Long - term debt and equity are not. The company maintains a...

Q:

Individually design a job specifi cation for a university lecturer in marketing, then compare results in groups of fi ve. Produce a fi nal version taking the best parts of each of your efforts.

Q:

Set out some of the opportunities presented to Sarah in the Meteor Telecoms case study. How would she best take advantage of them?

Q:

It is often said that competencies for a manufacturing environment are different to those for a service environment. Draw up a list of fi ve differing competencies for each sector and three...