Load SQL File: /* log in as SYSTEM and run this script */ SET ECHO ON SET SQLBLA

Question

Load SQL File:

/* log in as SYSTEM and run this script */
SET ECHO ON
SET SQLBLANKLINES ON

REM The next command will fail on the first run
DROP USER iggy CASCADE;
CREATE USER iggy PROFILE DEFAULT
IDENTIFIED BY oracle DEFAULT TABLESPACE USERS
ACCOUNT UNLOCK;
GRANT CONNECT TO iggy;
GRANT RESOURCE TO iggy;

CREATE TABLE iggy.supplier (
supplierName VARCHAR(32) NOT NULL,
PRIMARY KEY (supplierName))
TABLESPACE USERS;

CREATE TABLE iggy.part (
partName VARCHAR(32) NOT NULL,
PRIMARY KEY (partName))
TABLESPACE USERS;

CREATE TABLE iggy.quote (
supplierName VARCHAR(32) NOT NULL,
partName VARCHAR(32) NOT NULL,
quote NUMBER(8,2) NOT NULL,
PRIMARY KEY (supplierName,partName),
FOREIGN KEY (supplierName) REFERENCES iggy.supplier,
FOREIGN KEY (partName) REFERENCES iggy.part)
TABLESPACE USERS;

/* ------------ Add Data to Tables -------------- */

INSERT INTO iggy.supplier
VALUES ('NEW YANKEE WORKSHOP, INC.');
INSERT INTO iggy.supplier
VALUES ('OLD YANKEE WORKSHOP, INC.');
INSERT INTO iggy.supplieR
VALUES ('TOOL TIME, INC.');

INSERT INTO iggy.part
VALUES ('HAMMER');
INSERT INTO iggy.part
VALUES ('NAIL');

INSERT INTO iggy.quote
VALUES ('NEW YANKEE WORKSHOP, INC.','HAMMER','1.89');
INSERT INTO iggy.quote
VALUES ('NEW YANKEE WORKSHOP, INC.','NAIL','0.19');
INSERT INTO iggy.quote
VALUES ('OLD YANKEE WORKSHOP, INC.','HAMMER','2.09');
INSERT INTO iggy.quote
VALUES ('TOOL TIME, INC.','HAMMER','1.99');
INSERT INTO iggy.quote
VALUES ('TOOL TIME, INC.','NAIL','0.20');

INSTRUCTIONS

Download the scipt provided above (LoadDB.sql) to C:CIS4210

Run sqlplus SYSTEM/Oracle11

Enter START C:CIS4210LoadDB.sql

Enter SPOOL C:CIS4210M1spool.txt

DESCRIBE iggy.part;

SELECT * FROM iggy.part;

DESCRIBE iggy.supplier;

SELECT * FROM iggy.supplier;

DESCRIBE iggy.quote;

SELECT * FROM iggy.quote;

SPOOL OFF;

QUIT;

I would need the spool.txt file

Explanation / Answer

Solution:

code:

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

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