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 (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
Get step-by-step solutions from verified subject matter experts
