PL/SQL Programming  «Prev  Next»

Course Project Files Required

Download Programming PL/SQL files


Objective: Download the course project files and the SQL script .

Exercise scoring

When you have completed the exercise, click the Submit button below.

Instructions

Follow these steps to complete the exercise:
  1. Click the petstore.sql link.
  2. Your browser will ask you what you want to do with the file. Choose "Save to disk".
  3. Specify that the file be saved in the directory

    C:\programming-pl-sql

  4. If you do not have an Oracle database to use during the course, use MySQL running as localhost.
    Continue with these steps to install the course project on your database.
  5. Open the petstore.sql file in a text editor. A few lines into the script is the following line:
    CONNECT PETSTORE/GREATPETS;
    

    This line works only if you run Oracle on your own computer. If you are running on a networked database, modify the line to include your database server name. For example, if your database server was named FRANCE, you would modify the line to say:
    CONNECT PETSTORE/GREATPETS@
    
  6. Save the file with the change. Keep the same name for the file.
  7. Get to a command prompt and change directories to the directory where you stored your file. If you are running MS Windows, select Start/Programs/Accessories/Command Prompt.
    On UNIX, start a terminal window if needed. The command for changing to a directory in Windows and UNIX is: Cd directoryname Be sure to type the full path of the directory.
  8. Type this command at the operating system prompt: Sqlplus username/password@server You must log in as a valid Oracle database administrator (DBA).
    The default user name and password of the Oracle DBA is SYSTEM and MANAGER. If you are using a database on your local computer, you can leave out the @server portion.
    Otherwise, fill in the name of the database server on your network. This starts up SQL*Plus.
    You will see a prompt that looks like this:SQL>
  9. Execute the complete script by typing this line and pressing Enter: start petstore.sql
  10. When the script is done, you will automatically return to your operating system prompt.
    Exit the operating system window (not always needed in UNIX) by typing EXIT and pressing Enter. You now have installed the PETSTORE user in your Oracle database along with the user's data.
For the purposes of this course, we will assume that you have placed your course downloads in the C:\programming-pl-sql folder.
If you choose to place the course downloads elsewhere, make a note of the folder name so that you can find it later.