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;

what is the difference between char and varchar data types? : Sql dba

1126

---

What is interval partition?

1061

---

If a cursor is open, how can we find in a pl/sql block?

1167

---

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

1091

---

Explain the components of sql?

1068

---

What is a null value?

1150

---

Is clustered index a primary key?

951

---

What is the difference between rename and alias?

1346

---

What is error ora-01000: maximum open cursors exceeded

1150

---

Why do we use procedures in pl sql?

1045

---

How to assign sql query results to pl sql variables?

1086

---

What is foreign key and example?

942

---

What is difference between stored procedures and application procedures?

1021

---

What is the execution plan in sql?

1031

---

Why is sql better than hql?

999

---