Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

murach's Oracle SQL and PL/SQL

javaMan2012Jun 8 2012 — edited Jun 10 2012
Hi friends,

I posted this in another forum, as I am waiting for a response, I thought of posting here as well:

I am totally new to Oracle SQL and PL/SQL. So I purchased the above mentioned e-book to learn. I seem to have some difficulty in getting somethings up and running, really hope someone can help.

As per the instruction given I downloaded and installed the necessary files. I ran the 'setup_database.bat'which was supposed to install all the tables and users. When I checked the log file, there are lines and lines of 'table created' and '1 row created' messages. I am curious as to what exactly did the 'setup_database.bat' file create? All I see when I open the file in notepad is this:


+@ECHO off+
+:: Murach's Oracle SQL and PL/SQL+

+:: Mike Murach & Associates, Inc.+

+:: Jan 1, 2008+

+::+

+:: Uses SQL*Plus utility to run the SQL scripts that create+

+:: and populate the tables in the AP, OM, and EX schemas.+


+:: If necessary, edit the username/password+

sqlplus system/system @setup_database


+:: Display a message about the log file+

ECHO.

ECHO For details, check the setup_database.log file in the current directory.

ECHO.


+:: Display 'press any key to continue' message+

PAUSE

Really hope someone can advise. Thanks.


regards
John
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2012
Added on Jun 8 2012
8 comments
1,943 views