Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Chapter 2

A1:	n/a
A2:	n/a
A3:	n/a
A4:	l
A5:	l1
A6:	l1 c/last_name/first_name l3 c/last_name/first_name
A7:	Save c:/prob7.sql
A8:	Start c:/prob7.sql
A9:	Create table manufacturers (manufacturer char(3), manufacturer_name varchar2(20)); Create table circuit_breaker_models (model varchar2(20), fk_manufacturer char(3), gallons_of_oil number(4,0), kva_rating number(4,1), a mps number(4,0), weight number(6,0)); create table circuit_breakers (serial_number varchar2(20), fk_model varchar2(20), location varchar2(30)); create table circuit_breaker_tests (fk_serial_number varchar2(20), test_date date, test_result number(5,1)); create table circuit_breaker_text (fk_serial_number varchar2(20), text_line_number number, text varchar2(300));
A10: ...