Question: 6-1.In this exercise, you will test the UNION operator. Having seen how the union operator works demonstrate some permutations to see what will work legally

6-1.In this exercise, you will test the UNION operator. Having seen how the union operator works demonstrate some permutations to see what will work "legally" and what will not. First, create two tables Tablel Table? C D 1 x2 y2Z2 w2 rl Let the type of A's and B's be CHAR(2) Let the type of C in Table2 be VARCHAR2(2) and D in Table2 be VARCHAR2(3) Try the following statements and note the results SELECT * FROM Tablel UNION SELECT * FROM Table2; SELECT * FROM Tablel UNION SELECT A,B FROM Table2; SELECT * FROM Tablel UNION SELECT B,AFROM Tablel; SELECT * FROM Tablel UNION SELECT A,CFROM Table2; SELECT * FROM Tablel UNION SELECT A,D FROM Table2; CREATE OR REPLACE VIEW viewx AS SELECT A,B FROM Table2; SELECT * FROM TablelUNION SELECT FROM viewx
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
