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

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

by John Adolph Palinski
August 2002
Intermediate to advanced content levelIntermediate to advanced
528 pages
10h 12m
English
Addison-Wesley Professional
Content preview from 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: ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Expert PL/SQL Practices for Oracle Developers and DBAs

Expert PL/SQL Practices for Oracle Developers and DBAs

John Beresniewicz, Adrian Billington, Martin Büchi, Melanie Caffrey, Ron Crisco, Lewis Cunningham, Dominic Delmolino, Sue Harper, Torben Holm, Connor McDonald, Arup Nanda, Stephan Petit, Michael Rosenblum, Robyn Sands, Riyaj Shamsudeen
Beginning Oracle SQL: for Oracle Database 12c, Third Edition

Beginning Oracle SQL: for Oracle Database 12c, Third Edition

Lex De Haan, Tim Gorman, Inger Jørgensen, Melanie Caffrey

Publisher Resources

ISBN: 0201752948Purchase book