Question: use sql+ Q No 2: Practical 1. Select ename , it's managers ename , dname from dept table and manager's grade from salgrade table. ENAME

use sql+

Q No 2: Practical 1. Select ename , it's managers ename , dname from dept table and manager's grade from salgrade table. ENAME MANAGER_NAME MANAGER_DNAME MANAGER_GRADE JONES BLAKE CLARK ADAMS SMITH KING KING KING SCOTT FORD ACCOUNTING ACCOUNTING ACCOUNTING RESEARCH RESEARCH 5 5 5 4 4 Essentials of Oracle 97 FORD SCOTT JAMES WARD ALLEN TURNER MARTIN MILLER JONES JONES BLAKE BLAKE BLAKE BLAKE BLAKE CLARK RESEARCH RESEARCH SALES SALES SALES SALES SALES ACCOUNTING 2. Display all those employees whose manager has letter A in their name. EMP_NAME MANGER_NAM ALLEN BLAKE WARD BLAKE MARTIN BLAKE TURNER BLAKE JAMES BLAKE MILLER CLARK 3. Display employee name along with employee's grade and manager name along with manager's grade. ENAME GRADE ENAME GRADE SMITH 1 FORD JAMES 1 BLAKE ADAMS 1 SCOTT WARD 2 BLAKE MARTIN 2 BLAKE MILLER CLARK TURNER BLAKE ALLEN 3 BLAKE CLARK 4 KING BLAKE 4 KING JONES KING + Q No 2: Practical 1. Select ename , it's managers ename , dname from dept table and manager's grade from salgrade table. ENAME MANAGER_NAME MANAGER_DNAME MANAGER_GRADE JONES BLAKE CLARK ADAMS SMITH KING KING KING SCOTT FORD ACCOUNTING ACCOUNTING ACCOUNTING RESEARCH RESEARCH 5 5 5 4 4 Essentials of Oracle 97 FORD SCOTT JAMES WARD ALLEN TURNER MARTIN MILLER JONES JONES BLAKE BLAKE BLAKE BLAKE BLAKE CLARK RESEARCH RESEARCH SALES SALES SALES SALES SALES ACCOUNTING 2. Display all those employees whose manager has letter A in their name. EMP_NAME MANGER_NAM ALLEN BLAKE WARD BLAKE MARTIN BLAKE TURNER BLAKE JAMES BLAKE MILLER CLARK 3. Display employee name along with employee's grade and manager name along with manager's grade. ENAME GRADE ENAME GRADE SMITH 1 FORD JAMES 1 BLAKE ADAMS 1 SCOTT WARD 2 BLAKE MARTIN 2 BLAKE MILLER CLARK TURNER BLAKE ALLEN 3 BLAKE CLARK 4 KING BLAKE 4 KING JONES KING +

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!

SQL Queries to Develop Develop SQL statements using the EMP and DEPT tables explained in Oracle APEX. Use Oracle APEX to try out and test each SQL statement. Note that SAL is a month salary. Send in...

SQL Queries to Develop SQL statements. Develop SQL statements using the EMP and DEPT tables explained in the lecture notes and available in Oracle APEX. Use Oracle APEX to try out and test each SQL...

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

DROP TABLE EMP; DROP TABLE DEPT; DROP TABLE BONUS; DROP TABLE SALGRADE; CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7,...

Start SQL*Plus database: CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT...

I need sql query Question 1. Find employees' data, hired on MANAGER position in NEW YORK or CHICAGO. Sort them by descending salaries 3. Create all pairs of employees' names who work in the same...

Display the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the nearest whole number. Modify the...

please use sql+ 10. Select employee's name, employee's department name, employee 'sgrade and also it's manager's ename , manager's dname and 100 Chapter 4 - Querying Multiple Tables manager's grade....

Hello, I am taking an Intro to Database Management Course and there are a few queries that I need help on for an assignment. I have posted the SQL code that the instructor wants us to work with and...

What are the three key managerial functions? Provide examples of each function. How does cost accounting impact how managers discharge their duties in each function? Your answer should be a minimum...

Discuss the conflict between privacy and freedom of speech

Section 2 A - 5 2 5 ( 2 ) of the Uniform Commercial Code allows a lessor to Blank _ _ _ _ _ _ goods when the lessee fails to make payments according to the lease terms.

Kiona Co. set up a petty cash fund for payments of small amounts. The following transactions involving the petty cash fund occurred in May (the last month of the company's fiscal year) 9 May 1...

=+young and relatively inexperienced employee? Is the IA part of an international cadre of expatriates who move from one foreign assignment to another or is the IA someone who seeks to become...

=+2 What is the purpose or reason for the international assignment? Is the assignment demand-driven (i.e., the IA is sent because the MNE wants control and

=+j Identify the challenges of dealing with various tax structures and methods affecting international assignment C&B.