Creating a script.

The script will create 2 tables, load the 2 tables with data and then using PL/SQL it will process those 2 tables and with 2 SQL statements produce the resulting output for the 2 processed tables.

The script must run completely and accurately to produce the proper output. A script that does not run properly will be considered incomplete and needs to be resubmitted and be complete. No marks for resubmission. Get it right the first time, please.

The script will create 2 tables

Table custxx where xx is replaced with your Oracle id

Table transxx where xx is replaced with your Oracle id

CUSTXX

Into custxx you will copy 2 columns from your customers table, cust_no and phone_no, but the new columns will be called cust_no, and balance. Only copy customers with cust_no up to 1050.

TRANSXX

This table needs to be created and contains the following columns.

COLUMN NAME DATA TYPE 1 CUST NO NUMBER ( 4 , 0) 2 OPERATION CHAR (1 BYTE) 3 AMOUNT NUMBER ( 7 , 0) 4 STATUS VARCHAR2 (50 BYTE) 5 WHEN DATE