Answer Posted / elumalai d

--QUESTION36:-What is different between union and minus?

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;

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;

DROP TABLE question36;
DROP TABLE quest36;

How do I delete a trigger?

1013

---

what are string data types? : Sql dba

1093

---

What is the difference between mdf and ndf files?

1159

---

What is package in pl sql with an examples?

1083

---

What is the best sql course?

1026

---

what is the difference between a having clause and a where clause? : Sql dba

1156

---

What is a system versioned table?

1040

---

Explain the the delete statements in sql?

1114

---

Is inner join faster than left join?

1249

---

What is the difference between nested table and varray?

1050

---

How do you update a value in sql?

1101

---

Is drop table faster than truncate?

1048

---

Why do we use set serveroutput on?

1011

---

What is sql mysql pl sql oracle?

1127

---

Can variables be used in sql statements?

1073

---