The relational set operators UNION, INTERSECT, and MINUS work properly only if the relations are union-compatible. What does union-compatible mean, and how would you check for this condition?
Answer to relevant QuestionsWhat is the difference between UNION and UNION ALL? Write the syntax for each.What is embedded SQL, and how is it used?Insert the data into the tables you created in Problem1.Write a procedure to add a new invoice record to the INVOICE table. Use the following values in the new record:8006, 1000, ’30-APR-14’, 301.72Create a procedure named prc_cus_balance_update that will take the invoice number as a parameter and update the customer balance.
Post your question