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 rowid in sql?

905

---

How to execute a stored procedure?

1026

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

967

---

What is embedded sql what are its advantages?

958

---

How do I delete a trigger?

911

---

How long will it take to learn pl sql?

888

---

What are the types of join in sql?

1026

---

What is a dirty read sql?

1028

---

What is natural join in sql?

916

---

What is left join example?

886

---

What are the types of keys?

925

---

What is the advantage of nosql?

990

---

Why do we need a foreign key?

1014

---

How do you sort in sql?

947

---

What are the set operators in sql?

1027

---