Help get this topic noticed by sharing it on Twitter, Facebook, or email.
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 firstname.lastname@example.org or call them at:
1-707-827-7019 (outside the USA)
7:30 am to 5:00 PST
Customer Service Representative
You can download the sample code for the book here -
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.
O'Reilly Book Support
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.
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.
O'Reilly Book Support