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
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
No comments:
Post a Comment
Please Provide your feedback here