B,E
create table products (prod_id char(2), prod_name char(4), exp_date timestamp(6));
create table new_products (prod_id char(4), prod_name varchar2(10), exp_date DATE);
/*A NOOK 01789. 00000 - "query block has incorrect number of result columns"*/
SELECT prod_id FROM products
UNION ALL
SELECT prod_id, prod_name FROM new_products;
/*B OK.*/
SELECT prod_id, exp_date FROM products
UNION ALL
SELECT prod_id, NULL FROM new_products;
/*C NOOK 01789. 00000 - "query block has incorrect number of result columns"*/
SELECT * FROM products
MINUS
SELECT prod_id FROM new_products;
/*D NOOK 01790. 00000 - "expression must have same datatype as corresponding expression"*/
SELECT prod_id, prod_name FROM products
INTERSECT
SELECT 100, prod_name FROM new_products;
/*E OK*/
SELECT * FROM products
UNION
SELECT * FROM new_products;
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
SantiBZ_07032022_1744
Highly Voted 1 year, 5 months agoyaya32
Most Recent 6 months, 2 weeks agolucemqy
8 months, 3 weeks agoAjinkya_Tambe
9 months agoESZ
10 months, 1 week agofasolazgrochem
11 months agoShrimathi
1 year agoWingL
1 year ago