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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!