Question: Lab Part (50 points) Preliminary 1) Login into the Linux machine (oraclelinux.eng.fau.edu) 2) Connect to database (e.g., sqlplus username/password) 3) ALTER SESSION SET CURRENT_SCHEMA =

 Lab Part (50 points) Preliminary 1) Login into the Linux machine

Lab Part (50 points) Preliminary 1) Login into the Linux machine (oraclelinux.eng.fau.edu) 2) Connect to database (e.g., sqlplus username/password) 3) ALTER SESSION SET CURRENT_SCHEMA = COP6731; 4) Please note that the schema name is defined as upper case characters. 5) Execute the following SQL and identify all required tables. SELECT table_name from all_tables where owner = 'COP6731'; Please note that the owner's name is defined as upper case characters. 6) Change line size: SET LINESIZE 400 Use the "spool" command to create a log file for the output of SQL (e.g., SPOOL filename and SPOOL OFF) Note: Submit both SQLs and SPOOL files (i.e., SQL statements and a SPOOLfile). Consider the following relational schemas

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!