6-1.In this exercise, you will test the UNION operator. Having seen how the unio

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" 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;

Explanation / Answer

Based on the above tables and datatypes, I have created tables with the above data.

select * from Table1 union select * from Table2;

Result: Error: SELECTs to the left and right of UNION do not have the same number of result columns

select * from Table1 union select A,B from Table2;

Result:

select * from Table1 union select B,A from Table1;

Result:

xl

select * from Table1 union select A,C from Table2;

Result:

select * from Table1 union select A,D from Table2;

Result:

create view viewx as
select A,B from Table2;

Result: View Created

SELECT * from Table1 union select * from viewx;

Result:

//** Hit like if you like the answer

//Comment for any other explanation.

A B r2 s2 rl sl x2 y2 xl yl

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.