Oracle SQL Jumpstart with Examples- P13: Review "As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single. | 570 SCHEMAOLTPSQL SPOOL log DROP USER MUSIC CASCADE CREATE USER MUSIC IDENTIFIED BY MUSIC DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS QUOTA UNLIMITED ON TEMP GRANT CONNECT RESOURCE TO MUSIC GRANT UNLIMITED TABLESPACE TO MUSIC SPOOL OFF SPOOL log DROP TABLE INSTRUMENT CASCADE CONSTRAINTS CREATE TABLE INSTRUMENT INSTRUMENT_ID NUMBER NOT NULL SECTION_ID NUMBER NULL NAME VARCHAR2 32 NOT NULL CONSTRAINT XPKINSTRUMENT PRIMARY KEY INSTRUMENT_ID CONSTRAINT FKI_1 FOREIGN KEY SECTION_ID REFERENCES INSTRUMENT CREATE UNIQUE INDEX XUK_INSTRUMENT_NAME ON INSTRUMENT NAME CREATE INDEX XFK_I_1 ON INSTRUMENT SECTION_ID DROP TABLE ARTIST CASCADE CONSTRAINTS CREATE OR REPLACE TYPE INSTRUMENTSCOLLECTION AS VARRAY 10 OF VARCHAR2 32 CREATE TABLE ARTIST ARTIST_ID NUMBER NOT NULL NAME VARCHAR2 32 NOT NULL STREET VARCHAR2 32 POBOX CHAR 20 CITY VARCHAR2 32 STATE_PROVINCE VARCHAR2 32 COUNTRY VARCHAR2 32 ZIP CHAR 10 EMAIL VARCHAR2 32 INSTRUMENTS INSTRUMENTSCOLLECTION Please purchase PDF Split-Merge on to remove this watermark. SCHEMAOLTPSQL 571 CONSTRAINT XPKARTIST PRIMARY KEY ARTIST_ID CREATE UNIQUE INDEX XUK_ARTIST_NAME ON ARTIST NAME DROP TABLE SONG CASCADE CONSTRAINTS CREATE TABLE SONG SONG_ID NUMBER NOT NULL ARTIST_ID NUMBER NOT NULL TITLE VARCHAR2 64 NOT NULL RECORDING_DATE DATE PLAYING_TIME CHAR 10 RECORDING BLOB CONSTRAINT XPKSONG PRIMARY KEY SONG_ID CONSTRAINT FKSONG_1 FOREIGN KEY ARTIST_ID REFERENCES ARTIST CREATE INDEX XFK_SONG_1 ON SONG ARTIST_ID CREATE UNIQUE INDEX XUK_SONG_TITLE ON SONG TITLE DROP TABLE GUESTAPPEARANCE CASCADE CONSTRAINTS CREATE TABLE GUESTAPPEARANCE SONG_ID NUMBER NOT NULL GUESTARTIST_ID NUMBER NO NULL COMMENT_TEXT VARCHAR2 256 CONSTRAINT XPKGUESTAPPEARANCE PRIMARY KEY SONG_ID GUESTARTIST_ID CONSTRAINT FKGUESTAPPEARANCE_1 FOREIGN KEY GUESTARTIST_ID REFERENCES ARTIST CONSTRAINT FKGUESTAPPEARANCE_2 FOREIGN KEY SONG_ID REFERENCES SONG CREATE
