Your project is complete and now you are ready to start testing. Your application reads data from one table, processes portions of the data and makes some changes, then inserts the changed data into two additional tables before committing the work. Errors are captured in an external SPOOL file for evaluation and aid in debugging after each test of the application. The process of checking the errors, recording the data, and then deleting the records before the next test run of the application is somewhat time-consuming. The notion of creating a set of temporary tables for the output tables seems to be a good solution.
For this part of the exercise, write and execute the SQL commands to create two temporary tables.
* The first table should be named CUSTORD_TEMP and should have columns for customer name and total order amount.
* The second table should be named CUSTORDTOT_TEMP and should have columns for customer order number, total state tax, and total shipping charges.
In your own words, explain why you might use temporary tables for testing your application.