O'Reilly logo

Oracle SQL by Carol McCullough-Dieter, Gavin JT Powell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

A

MUSIC schema scripts can be found from a simple menu on my website at the following URL, along with many other goodies including my resume.

http://www.oracledbaexpert.com/oracle/OracleSQLJumpstartWithExamples/index.html.

A.1 MUSICMASTER.SQL

SET ECHO OFFUNDEF DBNAMEPROMPT WHAT IS THE DATABASE OR NETWORK NAME? (SUCH AS: ORADB10)ACCEPT DBNAMEPROMPT CONNECTING TO SYSTEM NOW.CONNECT SYSTEM@&&DBNAME@CREATEUSER.SQLCONNECT MUSIC/MUSIC@&&DBNAME@SCHEMAOLTP.SQL@SEQUENCES.SQL@INSTRUMENT.SQL@ARTIST.SQL@GENRE.SQL;@MUSICCD.SQL@SONGANDTRACK.SQL@GUESTARTIST.SQL@STUDIOTIME.SQL@UPDATEDATA.SQL@CHECKDATA.SQL@SCHEMADW.SQL@DIMENSIONS.SQL@FACTS.SQLEXIT;

A.2 CREATEUSER.SQL

SPOOL log/CREATEUSER.LOG;DROP USER MUSIC CASCADE;CREATE USER MUSIC IDENTIFIED BY MUSICDEFAULT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required