Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SQL file

Hi, I recently purchased Oracle PL/SQL 5th ed and I'm new to programming. I have SQL*Plus up and running but how do I open and use the SQL code files to follow along with the book?
1 person has
this question
+1
Reply
  • Greetings,

    I have forwarded your question on to our Book Tech staff, so they can help you find a solution. If you ever have any questions or issues with the content of a title, you can also contact them directly at booktech@oreilly.com or call them at:

    1-800-889-8969
    or
    1-707-827-7019 (outside the USA)
    7:30 am to 5:00 PST

    Kind regards,
    Paul Fichera
    Customer Service Representative
    O'Reilly Media
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • Hi,

    You can download the sample code for the book here -
    http://examples.oreilly.com/978059651...

    Chapter 2 tells you how to get started with PL/SQL, and contains sections like "Starting Up SQL*Plus", "Running a SQL Statement", "Running a PL/SQL Program", "Running a Script", and "What Is the “Current Directory”?".

    If you've read through that and have a specific question, please let me know.

    Best regards,
    Chris Olson
    O'Reilly Book Support
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • Hi Chris,

    Thank you for your response. I am however still experiencing the same issue after rereading Chapter 2 and searching for potential solutions online as well. I do have the sample code downloaded for the book in addition an instance of SQL*Plus that states it's connected to Oracle. It however does not appear to be accessing the required tables when I am going through the tutorial.

    For example on page 28 under "Running a SQL Statement" I input the following text as outlined from the book, "select isbn, author, title from books;" at the SQL> prompt. When I do so the following message appears: "ERROR at line 1: ORA-00942: table or view does not exist".

    I am not sure what could be causing this and have similar messages when I continue through the chapter with a lot of the code inputs. Do I need to have another program running while I'm working in SQL*Plus? Please bear in mind that this is the first time I have attempted to set up these programs on my computer and have previously just used tutorials found online, meaning I may have missed something obvious to an experienced programmer.

    Thank you once again for your assistance regarding this issue.

    Best regards,

    Carl
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly

  • Hi Carl,

    Have you actually created the books table using the files that you downloaded? The table won't exist until you create it. If you'll check out the "file_index.html"
    that comes in the sample code folder, it will show you the files you'll need for Chapter 2, which includes a file called book.tab, which has the
    CREATE TABLE statement for books table used in Chapter 2.

    Best regards,
    Chris Olson
    O'Reilly Book Support
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly