Realistic Software Training

Author / Training Specialist / Developer

Oracle SQL & PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Introduction Posted Questions and Answers

 

John Palinski has been an instructor at the University of Nebraska at Omaha and Iowa Western Community College for the past seven years. He is noted for giving a great deal of practical advice in his courses. He provides on-site Oracle training for businesses. His courses are fast, fun, and to the point. He doesn't believe you want to spend five days in training when three will do. You like his book, contact us to find out how affordable it is to have him teach this course at your company.

Page	Question Date	Question	Answer
	9/16/2002	I am having installing the sample database from your book of the above title.In the provided CD-ROM there is no move.bat file in the practise database as shown in the above attachment which comes with the book.The only files that came in the sample database are those found in the attachment. Also i could not find the intro directory in the CD-ROM, could you please send me by mail the correct sample database file of your book Oracle SQL and PL/SQL Handbook as soon as possible because i would like to practise from your wonderful book the SQL queries.Thank You. Oliver Koh	Apparently the book reference and CD are out of sync.  The database is located in the PRACTICE_DATABASE directory on the CD.    If for some reason, you cannot find it, you can download the database from the following site: http://www.oracle-trainer.com/oracle_int.shtml.  But you sent me the database files, so you have them. You do not have to use the MOVE.bat file and longer.  If the following is true, you can install the database by double-clicking the INSTALL.bat file: 1. You have installed the Oracle database.  This will set the Path statement.  This allows the Bat file to locate the SQLPLUSW and SQLLDR executables. 2. The CD is on your D drive. 3.  You are using scott/tiger as your Oracle ID. Then all you have to do is double-click the INSTALL.bat file.  The BAT file has commands for opening SQL*Plus, creating the tables, closing SQL*Plus and launching SQL Loader.  SQL Loader will populate the tables.   If any of the above are false, you will have to correct the bat file or make sure the three tasks are complete.
	10/16/2002	On Mon, 14 Oct 2002 08:53:07 -0700 (PDT) K B  wrote: Dear training team,    Great book, just need a little more assistance in installing the practice tables, these are the steps I understood.  1. I placed the CD-ROM into my D drive  2. double clicked on CD  3. it opened to a list of  folders labled chapters approximately 1-16, and one practice_database folder.  4. I clicked on the practice_database folder.  5  it opened to additional items, the first item was the install icon.  6. I doubled clicked on the install icon, it appeared to load something in a black box, maybe it was the sql-loaded not sure.  7.by the way I did copy all the folders to my C-drive. I drag them from the D-drive.  8. all the while I had oracle personal edition open.  9. I went to the sql prompt and typed the first command; SELECT  last_name from employee 10. results were table does not exit. from here i got lost!!!!   Last issue::: MS-DOS for creating and populating the  database sqlplusw/scott/tiger @d:\practice_database\tabl_cre.sql    I tried to run @d:\practice_database\tabl_cre.sql    from my sql prompt.it didn't work do I need to put sqlplusw somewhere first. not sure please include step by step instructions to run these scripts    Sincerely,  -ken   Second E-mail On Mon, 14 Oct 2002 21:04:08 -0700 (PDT) K B  wrote: John,    Those instructions worked and presented brilliantly. Now I am ready for the second phase to load the data, hopefully it will go just as smooth.    p.s. Thanks for responding so quickly, I know your very busy.    -ken Third E-mail   John, I live in ---------, California.... Iam very excited now, it works. thank you thank you thank you thank you thank you	My response to the first e-mail: I'm not sure what the problem is but there are two thing that are needed to load the database.  You must install the tables and you must load them with SQL*Loader.  Let's get your table's first.  1. You got into SQL*Plus.  Type in "Selet * from tab;" You will see a lot of  writing scroll by.  This means you are in SQL*Plus and Oracle is working.  2.  Open the Tabl_cre.sql file using Editpad or Notepad.  3.  Highlight and copy everything in the file to Windows Clipboard (ctrl-c).  4.  Paste the Clipboard contents into SQL*Plus at the SQL prompt.  You should see words indicating tables are created.  5.  Test to see if the tables exist by entering "desc employee" at the SQL prompt.  All of the tables columns should appear.  This means you have created the table.  Try this then we can worry about loading the data.   Response to second e-mail Ken:  The next step is to load the data files.  This will require the use of SQL*Loader.  You will have to execute these commands from a DOS prompt.  1.  The first task is to locate SQL*Loader.  Open up a DOS window.  This can be done by clicking the Accessories/Command prompt Windows Start menu option. 2.  When the window is open, enter "sqlldr".  3.If the computer returns a bunch of verbage, you are in good shape.  The path was set correctly by Oracle and your computer knows where the sqlldr exec is. You can skip the next step.   If the computer couldn't find the file then you path was not set correctly, SQL*Loader was not installed, or you are using an older version of Oracle. Unfortunately Oracle did not use the same name on all previous versions.  In this case you must do the next step. 4.  In this step you need to determine whether you have SQL*Loader and where it is located. Use the Windows Find facility.  Enter "sqlld*.exe".  If it returns a value, you now know its name and location.  If the file is called "sqlldr" then your path is set incorrectly.  You will need to run the scripts from the directory "sqlldr" is located.  Change directories so that that directory is the current directory. Go to step 5, If it returns a value, return to step 2 using the new name rather than the original.   5.  The tables are loaded by executing five commands from the command line. The batch file can execute these but something didn't work so you can enter them from the DOS prompt.  This will help determine what the problem is.  Open the INSTALL.bat file using Notepad or Editpad.  You will see five commands like the following: sqlldr scott/tiger control= d:\practice_database\loaddept.ctl log=c:\ld.log bad=c:\ld.bad Note the "SQLLDR" exec and the file paths.  Enter the command making sure that SQLLDR is valid, that scott/tiger is the name of your database, and the file paths are correct.  If SQL*Loader is available, the database name is correct, and the path names are correct you should not have any problems. John By the way, I have a hobby of tracking the locations from which people contact.  What city do you live in?