Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 =

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Oracle8I Building Efficient Databases

Authors: Jonathan Lewis

1st Edition

0201715848, 978-0201715842

More Books

Students also viewed these Databases questions