Re: Real-life PL/SQL these days ...

  • From: Romeo Ybanez <raybanez@xxxxxxxxx>
  • To: kennaim@xxxxxxxxx, andrew.kerber@xxxxxxxxx, cary.millsap@xxxxxxxxxxxx
  • Date: Tue, 14 Apr 2009 20:09:44 -0700 (PDT)

I've been a PL/SQL programmer and used to maintain or fix codes where there are 
so many joined tables and subqueries.  I believe that if properly designed we 
don't need to write very long codes and complex joins to get what we want.  
Some PL/SQL programmers try to impress those who will subsequently maintain 
their code. They think the harder it is to follow the better they are in 
writing those PL/SQL codes.

From: Kenneth Naim <kennaim@xxxxxxxxx>
To: andrew.kerber@xxxxxxxxx; cary.millsap@xxxxxxxxxxxx
Cc: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, April 15, 2009 1:52:36 AM
Subject: RE: Real-life PL/SQL these days ...

I find that many PL/SQL developers and
developers of PL/SQL code generators code as if PL/SQL wasn’t a database 
they tend to treat tables as text files and do not use the power of
database/sql. The second major issue I see is developers that learned to code 
copy and paste) pl/sql for Oracle 7 or 8 and not taking advantage of any of the
new features of SQL and PL/SQL. 
I spend a lot of time converting PL/SQL
into straight SQL using case statements and analytical and seeing significant
performance improvements, up to 3 orders of magnitude depending on how bad the
pl/sql was originally. 
While I’m sure I could learn a few things
from Cary ’s
PL/SQL developers, I also have some spare time to assist with rewriting PL/SQL
if anyone needs another set of eyes.
Ken Naim

From:oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Andrew Kerber
Sent: Tuesday, April 14, 2009 1:14
To: cary.millsap@xxxxxxxxxxxx
Subject: Re: Real-life PL/SQL
these days ...
From what I have seen, an
awful lot of that poor SQL comes from applications that generate SQL code,
often several pages in a single statement.  Another major problem is
poorly designed views.
On Tue, Apr 14, 2009 at 11:42 AM, Cary Millsap <cary.millsap@xxxxxxxxxxxx>
I've got some exceptionally good PL/SQL developers working for me, too.
They were very difficult to find.
We have some spare capacity, too, if anyone in Oracle-L land is looking for
help designing and writing PL/SQL code.

Cary Millsap

On Tue, Apr 14, 2009 at 11:27 AM, Jared Still <jkstill@xxxxxxxxx>
On Tue, Apr 14, 2009 at 7:12 AM, Dba DBA <oracledbaquestions@xxxxxxxxx>
There are some good ones, but they are hard to find. What makes it
harder is that pl/sql developers tend to make less than DBAs. So the smart ones
migrate to DBA work so they can get better compensation. This is not always the
case, but quite common. 

I've known a few.

Here's one:

I personally know a couple of other local folks that are quite good
with PL/SQL.  I've also known some that are not so good.

The problem here is not just developers that aren't good at PL/SQL,
it's developers that aren't good at development, regardless of language,
platform or database.

Some folks have carved out the wrong niche for themselves.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'


Other related posts: