For the Oracle tables you created and stored in the Lab exercise complete the following: Log on the Oracle server and start up SQLPLUS, as we have...

For the Oracle tables you created and stored in the Lab exercise complete the following:

Log on the Oracle server and start up SQLPLUS, as we have done in class.

Enter the following commands. The first will print out the data in your tables. The second will print out the SQL queries and the results. 

1.      Select * 

From Consultant;

Select *

From Client;

Select *

From Audit_T;

Select *

From Audit_Consultant;

Select *

From Zipcode;

2.     Add a column to the Consultant table called "Manager" defined as varchar2 for a length of 20.

       Update the new field with whatever data you choose, i.e. you can use the same value in all rows if 

​like. 

       Add your own name to the Consultant table, use an existing zipcode to avoid having to add a new 

​one. 

3.      Write SQL commands to answer the following questions: