Hi, I am taking Oracle class. I have this assigment and I am not sure what to do

Question

Hi, I am taking Oracle class. I have this assigment and I am not sure what to do with it. Can someone please looka at this and give me some pointers how to start?

Written Assignment Due: Friday Points: 65 Run SQL Plus and run the script provided above using the START command and document the tables that were created . Download LoadDB sql to c ICIS421B . Run SQL Plus SYSTEM/Oracle11 .Enter START CICIS421BILoadDB sal Enter SPOOL C IeIS421BiS1spool txt DESCRIBE iegy part SELECIFROM oey part DESCRIDE iggy supplior ·SELECT FROM iggy,supplie DESCRIBE iggy quote SELECT FROM iggy quote Submiten cis421b SIspool txt to the form inside this felder Your now are able to run SQL Plus 199 oraci ho de tot vatious examples in the bock eo to the Assignment Subnission folder locate the link for this assionmentin orde to subimityoul attachmant toithe instructor

Explanation / Answer

Hi,

I am assuming that your system does have installed with Oracle client software and it connected to the oracle database. Below are the simplified explanations of the instructions shown in the assignment questionaire you posted.

1) LoadDB.sql :: is an sql file which usually contains instructions/commands that can be executed on the oracle client/tool

2) Run SQL*Plus System/Oracle11 ::SQL *Plus an User Interface where the commands can be executed

3) START %file-path%LoadDB.sql ::To import and the make the commands

available to environment

4) SPOOL :: to turn on the system cache to record/store the outputs of the

executed commands

5) Describe:: command used to list the columns of a table. In this case,

if DESCRIBE iggy.part - will display the table columns.

6) Select * from iggy.part :: displays all the columns of the available records

in part table of iggy schema.

7)DESCRIBE iggy.supplier :: Displays the columns presented in supplier

table of iggy schema.

8) SELECT * FROM iggy.supplier :: Displays the records available in

supplier table of iggy schema.

9) DESCRIBE iggy.quote; :: Displays the columns presented in quote

table of iggy schema.

10) SELECT * FROM iggy.quote; :: Displays he records available in

quote table of iggy schema.

11) SPOOL OFF; when executed the recording/capturing the results of executed

commands like SELECT and DESCRIBE will be turned off.

12) QUIT :: when executed you exiting from SQL * Plus

Now you will be able to see the spool.text file and that can be used further for your practise purpose.

Thanks and Happy learning!

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.