Answer Posted / elumalai d

UNOIN:- It returns all the records from both tables without duplicates.
Example:-
A={1,2,3,4}
B={2,3,4,5,6}
AUB={1,2,3,4,5,6}

CREATE TABLE question36 (empid NUMBER);
CREATE TABLE quest36 (empid NUMBER);

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(4);
INSERT INTO quest36 VALUES(5);
INSERT INTO quest36 VALUES(6);
COMMIT;

SELECT empid FROM question36
UNION
SELECT empid FROM quest36;

EMPID
---------
1
2
3
4
5
6

DELETE FROM question36;
DELETE FROM quest36;
COMMIT;

MINUS:- It returns table A values not available in table B.
Example:-
A={1,2,3,4}
B= {2,3,5}
A-B={1,4}

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(5);
COMMIT;

SELECT empid FROM question36
MINUS
SELECT empid FROM quest36;

EMPID
---------
1
4

DROP TABLE question36;
DROP TABLE quest36;

Is left join faster than inner join?

1076

---

What is the difference between explicit and implicit cursors in oracle?

1013

---

How global cursor can be declare with dynamic trigger ?

2163

---

how to decrement dates by 1 in mysql? : Sql dba

982

---

What are the dml statements?

1106

---

How to connect a sql*plus session to an oracle server?

1090

---

Can %notfound return null after a fetch?

1020

---

How to use sql statements in pl/sql?

1072

---

How to disable a trigger name update_salary?

1214

---

How subquery works in sql?

1018

---

How do I filter in sql profiler?

957

---

What is %type in pl sql?

934

---

What is recursive stored procedure?

1061

---

How would you pass hints to the sql processor?

943

---

Why is sql better than hql?

935

---