Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I am lucky and i am new to oracle.
I need to retrieve the data from emp table and dept table based on given input deptno and JOB
ENAME, E.DEPTNO, JOB , LOC FROM
EMP E , DEPT D where e.deptno=&dno and job ='&JOB' ;
if i enter 10 and clerk
If i write query like this it needs to diplay only MILLER Record only but the output like as below
MILLER 10 CLERK NEW YORK
MILLER 10 CLERK DALLAS
MILLER 10 CLERK CHICAGO
MILLER 10 CLERK BOSTON
Please help me on this.
Try with this,
SELECT E.ENAME, E.DEPTNO, E.JOB , D.LOC
FROM EMP E , DEPT D
AND job ='&JOB' ;
Please take training on SQL.