Newsgroups: comp.databases.oracle.server
Path: archiver1.google.com!news1.google.com!news.glorb.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newspeer.radix.net!news.er.usgs.gov!news
From: Brian Peasland <dba@remove_spam.peasland.com>
Subject: Re: Oracle9i: Program with PL/SQL Course Advise
X-Nntp-Posting-Host: edcxpw014.cr.usgs.gov
Content-Type: text/plain; charset=us-ascii
Message-ID: <4076C9DA.6974DAB2@remove_spam.peasland.com>
Sender: n...@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739)
Content-Transfer-Encoding: 7bit
Organization: U.S. Geological Survey, Reston VA
X-Accept-Language: en
References: <306fadc.0404090752.5c0c179b@posting.google.com>
Mime-Version: 1.0
Date: Fri, 9 Apr 2004 16:05:46 GMT
X-Mailer: Mozilla 4.78 [en] (Windows NT 5.0; U)
Lines: 35

Joe I wrote:
> 
> I have to learn PL/SQL and would like to take the "Oracle9i: Program
> with PL/SQL" course.  The prerequisites are "Working with iSQL*Plus"
> and "Introduction to Oracle9i: SQL". I'm a programmer and  have been
> working with SQL for several years and I would like to believe that I
> have a good working knowledge of it but I can't honesty say I know
> everything covered in the Introduction to Oracle9i: SQL course. My
> question is how much SQL do I really need to know for the Oracle9i:
> Program with PL/SQL course ? This might be a tough question to answer
> but any advise would be appreciated.


You really don't need that much SQL for the PL/SQL course. The SQL
course goes through nice things like SELECT, INSERT, UPDATE, DELETE, and
then things escalate from there. For the PL/SQL course, you pretty much
need a good understanding of SQL, but not everything about it. Your
PL/SQL work will involve some SQL statements. But if you understand
joins and aggregate functions, then you probably have enough to take the
course.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"