SQL> create table emp( 2 eid number(5) primary key, 3 dept varchar2(10), 4 sal number(9), 5 loc varchar. 6 SQL> create table emp( 2 eid number(5) primary key, 3 dept varchar2(10), 4 sal number(9), 5 loc varchar(9)); Table created. SQL> desc emp; Name Null? Type ----------------------------------------- -------- ---------------------------- EID NOT NULL NUMBER(5) DEPT VARCHAR2(10) SAL NUMBER(9) LOC VARCHAR2(9) SQL> create table dept( 2 did number(5), 3 client varchar(9), 4 domain varchar(10)); Table created. SQL> desc domain; ERROR: ORA-04043: object domain does not exist SQL> desc dept; Name Null? Type ----------------------------------------- -------- ---------------------------- DID NUMBER(5) CLIENT VARCHAR2(9) DOMAIN VARCHAR2(10) SQL> insert into emp values(&eid,'&dept',&sal,'&loc'); Enter value for eid: 12 Enter value for dept: analytics Enter value for sal: 25000 Enter value for loc: blore old 1: insert into emp values(&eid,'&dept',&sal,'&loc') new 1: insert into emp values(12,'analytics',25000,'blore') 1 row created. SQL> / Enter value for eid: 34 Enter value for dept: marketing Enter value for sal: 20000 Enter value for loc: chennai old 1: insert into emp values(&eid,'&dept',&sal,'&loc') new 1: insert into emp values(34,'marketing',20000,'chennai') 1 row created. SQL> / Enter value for eid: 56 Enter value for dept: sales Enter value for sal: 15000 Enter value for loc: pune old 1: insert into emp values(&eid,'&dept',&sal,'&loc') new 1: insert into emp values(56,'sales',15000,'pune') 1 row created. SQL> / Enter value for eid: 78 Enter value for dept: banking Enter value for sal: 30000 Enter value for loc: mumbai old 1: insert into emp values(&eid,'&dept',&sal,'&loc') new 1: insert into emp values(78,'banking',30000,'mumbai') 1 row created. SQL> select * from emp; EID DEPT SAL LOC ---------- ---------- ---------- --------- 12 analytics 25000 blore 34 marketing 20000 chennai 56 sales 15000 pune 78 banking 30000 mumbai SQL> insert into dept values(&did,'&client','&domain'); Enter value for did: 12 Enter value for client: oracle Enter value for domain: sql old 1: insert into dept values(&did,'&client','&domain') new 1: insert into dept values(12,'oracle','sql') 1 row created. SQL> / Enter value for did: 34 Enter value for client: amazon Enter value for domain: web old 1: insert into dept values(&did,'&client','&domain') new 1: insert into dept values(34,'amazon','web') 1 row created. SQL> / Enter value for did: 87 Enter value for client: tcs Enter value for domain: banking old 1: insert into dept values(&did,'&client','&domain') new 1: insert into dept values(87,'tcs','banking') 1 row created. SQL> / Enter value for did: 567 Enter value for client: flipkart Enter value for domain: sales old 1: insert into dept values(&did,'&client','&domain') new 1: insert into dept values(567,'flipkart','sales') 1 row created. SQL> select * from dept; DID CLIENT DOMAIN ---------- --------- ---------- 12 oracle sql 34 amazon web 87 tcs banking 567 flipkart sales SQL> EQUI INNER JOIN SP2-0734: unknown command beginning "EQUI INNER..." - rest of line ignored. SQL> select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain 2 from emp inner join dept 3 on emp.eid=dept.did; EID DEPT SAL LOC DID CLIENT DOMAIN ---------- ---------- ---------- --------- ---------- --------- ---------- 12 analytics 25000 blore 12 oracle sql 34 marketing 20000 chennai 34 amazon web SQL> NON-EQUI INNER JOIN SP2-0734: unknown command beginning "NON-EQUI I..." - rest of line ignored. SQL> select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain 2 from emp inner join dept 3 on emp.eid!=dept.did; EID DEPT SAL LOC DID CLIENT DOMAIN ---------- ---------- ---------- --------- ---------- --------- ---------- 12 analytics 25000 blore 34 amazon web 12 analytics 25000 blore 87 tcs banking 12 analytics 25000 blore 567 flipkart sales 34 marketing 20000 chennai 12 oracle sql 34 marketing 20000 chennai 87 tcs banking 34 marketing 20000 chennai 567 flipkart sales 56 sales 15000 pune 12 oracle sql 56 sales 15000 pune 34 amazon web 56 sales 15000 pune 87 tcs banking 56 sales 15000 pune 567 flipkart sales 78 banking 30000 mumbai 12 oracle sql EID DEPT SAL LOC DID CLIENT DOMAIN ---------- ---------- ---------- --------- ---------- --------- ---------- 78 banking 30000 mumbai 34 amazon web 78 banking 30000 mumbai 87 tcs banking 78 banking 30000 mumbai 567 flipkart sales 14 rows selected. SQL> left OUTER JOIN SP2-0734: unknown command beginning "left OUTER..." - rest of line ignored. SQL> select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain 2 from emp left join dept 3 on emp.eid=dept.did; EID DEPT SAL LOC DID CLIENT DOMAIN ---------- ---------- ---------- --------- ---------- --------- ---------- 12 analytics 25000 blore 12 oracle sql 34 marketing 20000 chennai 34 amazon web 78 banking 30000 mumbai 56 sales 15000 pune SQL> Right OUTER JOIN SP2-0734: unknown command beginning "Right OUTE..." - rest of line ignored. SQL> select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain 2 from emp outer join dept 3 on emp.eid=dept.did; on emp.eid=dept.did * ERROR at line 3: ORA-00904: "EMP"."EID": invalid identifier SQL> select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain 2 from emp right join dept 3 on emp.eid=dept.did; EID DEPT SAL LOC DID CLIENT DOMAIN ---------- ---------- ---------- --------- ---------- --------- ---------- 12 analytics 25000 blore 12 oracle sql 34 marketing 20000 chennai 34 amazon web 87 tcs banking 567 flipkart sales SQL> select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain 2 select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain 3 / select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain * ERROR at line 2: ORA-00923: FROM keyword not found where expected SQL> Full OUTER JOIN SP2-0734: unknown command beginning "Full OUTER..." - rest of line ignored. SQL> select emp.eid,emp.dept,emp.sal,emp.loc,dept.did,dept.client,dept.domain 2 from emp full outer join dept 3 on emp.eid=dept.did; EID DEPT SAL LOC DID CLIENT DOMAIN ---------- ---------- ---------- --------- ---------- --------- ---------- 12 analytics 25000 blore 12 oracle sql 34 marketing 20000 chennai 34 amazon web 78 banking 30000 mumbai 56 sales 15000 pune 87 tcs banking 567 flipkart sales 6 rows selected. SQL> Cross JOIN SP2-0042: unknown command "Cross JOIN" - rest of line ignored. SQL> select * from emp cross join dept; EID DEPT SAL LOC DID CLIENT DOMAIN ---------- ---------- ---------- --------- ---------- --------- ---------- 12 analytics 25000 blore 12 oracle sql 12 analytics 25000 blore 34 amazon web 12 analytics 25000 blore 87 tcs banking 12 analytics 25000 blore 567 flipkart sales 34 marketing 20000 chennai 12 oracle sql 34 marketing 20000 chennai 34 amazon web 34 marketing 20000 chennai 87 tcs banking 34 marketing 20000 chennai 567 flipkart sales 56 sales 15000 pune 12 oracle sql 56 sales 15000 pune 34 amazon web 56 sales 15000 pune 87 tcs banking EID DEPT SAL LOC DID CLIENT DOMAIN ---------- ---------- ---------- --------- ---------- --------- ---------- 56 sales 15000 pune 567 flipkart sales 78 banking 30000 mumbai 12 oracle sql 78 banking 30000 mumbai 34 amazon web 78 banking 30000 mumbai 87 tcs banking 78 banking 30000 mumbai 567 flipkart sales 16 rows selected. SQL> spool off;