Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle SQLPlus books for newbie?
Michael Gast wrote:
> Richard B. Becker schrieb:
> > I work for a computer software company, and I've just
> > started to work with clients who are on the Oracle
> > version of our software. Basically, our software writes
> > a bunch of data to the Oracle database, and part of my job
> > is to help my clients write reports on that data, research
> > any scenarios where the program might be writing incorrect
> > data, and help the clients modify data if the program (or
> > the client) does something to mess it up.
> >
> > Unfortunately, my company's training methods are pretty weak,
> > so I'm looking to buy a book or two to train myself on Oracle
> > and SQLPlus. Obviously, playing around in the database using
> > SQLPlus is the most important part to me, but I'd also like
> > to learn what I can about installing and maintaining an
> > Oracle datbase on NT and HP-Ux environments.
> >
> > At this point, all I know is the absolute basics of SQLPlus
> > queries, and pretty much nothing else about Oracle databases.
> > I was thinking that it might be best to get two books: one
> > as an introductory "class" type book that goes through the
> > basics (SQL for Dummies, perhaps?), and the other being a
> > more encyclopedic reference to look up the more detailed
> > questions that might come up.
> >
> > Does anyone have recommendations for the best books for
> > this? Any advice would be appreciated!
> >
> > --Richard
>
> Hi Richard,
>
> are you using SQLPlus or the SQLPlus workbench? If it is the first, then
> i suggest you to have a look on other tools like TOAD from Quest
> Software (www.quest.com). There is free program version available.
>
> In my opinion, SQLPlus is only good for executing scripts and not for
> realizing PL/SQL apps. The user interface is quite dumb.
>
> --
> Due to spam, this eMail address is only used for newsgroup postings.
>
> All eMails sent to this address are immediately deleted. Therefore any
> eMails sent directly to this address will never be answered.
>
> Mit freundlichen Grüßen / Best Regards
> Michael Gast
> SEPP MED GmbH
I am aGhAST at your advice. One way to NEVER learn SQL*Plus is to hide it behind TOAD. In the classes I teach I insist that my students not use anything other than SQL*Plus because doing so interferes with both learning SQL but limits the student to Windows as a front-end. Not a good thing in the world of Oracle.
The best way to learn SQL*Plus is to get a copy and use it. For guidance print a coy of "Learning SQL*Plus Basics" available at:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a82950/ch2.htm#1001102
And be sure to click the Previous and Next buttons at the bottom left corner of the page.
And in the future when you have questions go to http://tahiti.oracle.com which is how I found the above link.
Daniel Morgan Received on Fri Sep 20 2002 - 10:16:12 CDT