Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started