University of West Florida COP 4710 OR6

Document Content and Description Below

SQL> CREATE TABLE Table1( 2 A CHAR(2), 3 B CHAR(2)); Table created. SQL> INSERT INTO Table1 VALUES ('x1', 'y1'); 1 row created. SQL> INSERT INTO Table1 VALUES ('r1', 's1'); 1 row created. SQL>... CREATE TABLE Table2 ( 2 A CHAR(2), 3 B CHAR(2), 4 C VARCHAR(2), 5 D VARCHAR(3)); Table created. SQL> INSERT INTO Table2 VALUES ('x2','y2','z2','w2'); 1 row created. SQL> INSERT INTO Table2 VALUES ('r2','s2','t2','u2'); 1 row created. SQL> SELECT * 2 FROM Table13 UNION SELECT A,B 4 FROM Table2; A B ------ ------ r1 s1 r2 s2 x1 y1 x2 y2 SQL> SELECT * 2 FROM Table1 3 UNION SELECT A,B 4 FROM Table2; A B ------ ------ r1 s1 r2 s2 x1 y1 x2 y2 SQL> SELECT * 2 FROM Table1 3 UNION SELECT B,A 4 FROM Table1 [Show More]

Last updated: 1 year ago

Preview 1 out of 12 pages