Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Do you use PL/SQL

Re: Do you use PL/SQL

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 30 May 2007 08:03:51 -0700
Message-ID: <1180537430.820121@bubbleator.drizzle.com>


www.douglassdavis.com wrote:
> Regarding the PL/SQL class:
>
> just as an update for all of you concerned citizens out there:
>
> not enough people signed up to make the class. I could possibly teach
> it in the fall, so I will prepare for then.
>
>
> If the class does have enough in the fall, I would like to focus on:
> - making scripts to automate certain tasks

There is essentially no reason for automating tasks using scripts in 10g and beyond. Task automation should be done in the OEM Grid Control or using DBMS_SCHEDULER.

> - making packages with procedures/functions

And learning how to use the initialization section and the implication of serially reusability on packages.

> - making triggers

Table triggers?
Instead-of triggers?
DDL Event triggers?
System Event triggers?

> - making methods using the OO features of Oracle
> (any other critical components?)

Read Tom Kyte's commentary on Oracle's OO features. My recommendation would be to stay away from them with the sole exception being object views with instead-of triggers.

> Since it will be taught in a computer lab, I will be focused more on
> practical hands on type things than lecture.

You can not separate the two. If the point is to teach syntax then they don't need you ... just a web connection. The point of being an instructor is to discuss best practice ... why BULK COLLECT and FORALL rather than CURSOR FOR LOOPS. What are the practical implications of PRAGMA AUTONOMOUS TRANSACTION. When to use positional rather than named parameter notation. What the differences are between passing parameters by reference with NOCOPY.

> Thanks for your help every one. I will run some more ideas past you
> all later on.
>
> Also, has any one read this book:
> Oracle PL/SQL Best Practices Optimizing Oracle Code
> By Steven Feuerstein
>
> Is it good? Is it still relevant (it's a 2001 book)?

Steven's book is good. But read Tom Kyte's books first for the necessary background.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed May 30 2007 - 10:03:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US