With10g_iSQLPlus.htm
 
Manas5 /Oracle 10g
 
Enterprise manager log in (Intranet )

connect system/Manas5 as Normal

iSQL*Plus

Connect as SYSTEM/Manas5 ;

DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=MANAS5)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))

 
Executing statement : select e.empno, e.ename, e.sal , e.deptno from scott.emp e;

SQL Query :

select e.empno, e.ename, e.job, e.sal from scott.emp e where e.DEPTNO IN (select DEPTNO from scott.DEPT e2 where e2.LOC = 'CHICAGO')
 

Natural Join:

select ename, job , deptno, loc from scott.emp natural join scott.dept where deptno = 30 or deptno = 10