Answer Posted / rahul gaikwad

Let's consider the difference between Minus and Union using
following examples.

1.create TABLE A AND B With similar structure
2.insert records in Table A and B.
3.Keep some records identical(here 2 rows).
4.find out the difference betwn 2 looking into the output.


CREATE TABLE A(NAME VARCHAR2(30));
INSERT INTO A VALUES('A');
INSERT INTO A VALUES('B');
INSERT INTO A VALUES('C');
INSERT INTO A VALUES('D');
COMMIT;

CREATE TABLE B(NAME VARCHAR2(30));
INSERT INTO b VALUES('A')
INSERT INTO b VALUES('B')
INSERT INTO b VALUES('Y')
INSERT INTO b VALUES('X')
COMMIT;



1) SELECT * FROM A
MINUS
SELECT * FROM B

NAME
------------------------------
C
D
2 rows selected



2)SELECT * FROM A
UNION
SELECT * FROM B


NAME
------------------------------
A
B
C
D
Y
x
6 rows selected

What is sql query limit?

506

---

Can you selectively load only those records that you need? : aql loader

607

---

What are two statement types in sql?

536

---

Does access use sql?

555

---

What is count * in sql?

551

---

---

Can you upgrade sql express to full sql?

513

---

What is package in pl sql with an examples?

545

---

Write a sql query to convert all character to uppercase after hypen.

957

---

what is data control language? : Sql dba

586

---

How do you update a sql procedure?

521

---

What are the methods of filing?

516

---

What are the disadvantages of file system?

617

---

What is difference between inner join and self join?

588

---

What are the events on which a database trigger can be based?

592

---

Does truncate release storage space?

555

---