Chapter 3, Problem 4CAT

Explanation of Solution

Running the script file of Colonial Adventure Tours:

The script file consists of create query for five tables and add values to be added in the created five table.

Steps to run the script file in oracle:

• Open the “SQL Workshop” in the menu bar.
• Then select “SQL Scripts” in the “LABEL”
• Click “Upload” option. The “Upload Script” window will appear on the screen.
• Click the “Choose File” option. Then specify the file path containing the script file and then click “Open” button.
• Click the “Upload” button.

  Screenshot of “Upload Script”

• Once the “Upload” button is clicked, the below table is displayed on the screen...