Re: Real-life PL/SQL these days ...
- From: Ian Cary <ian.cary@xxxxxxxxxxxxxx>
- To: raybanez@xxxxxxxxx
- Date: Wed, 15 Apr 2009 09:19:40 +0100
Another problem I've often seen is that people seem to get employed /
trained as PL/SQL developers without a decent grounding in SQL*Plus. Even
if their PL/SQL is of a reasonable standard you still often see several
procedures being written where a single SQL*Plus statement would do the job
far more efficiently.
|---------+----------------------------->
| | raybanez@xxxxxxxxx|
| | Sent by: |
| | oracle-l-bounce@fr|
| | eelists.org |
| | |
| | |
| | 15/04/2009 04:09 |
| | Please respond to |
| | raybanez |
| | |
|---------+----------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: kennaim@xxxxxxxxx, andrew.kerber@xxxxxxxxx,
cary.millsap@xxxxxxxxxxxx |
| cc: oracle-l@xxxxxxxxxxxxx
|
| Subject: Re: Real-life PL/SQL these days ...
|
>--------------------------------------------------------------------------------------------------------------|
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 language; 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 (or 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 PM
To: cary.millsap@xxxxxxxxxxxx
Cc: ORACLE-L
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>
wrote:
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
http://method-r.com
http://carymillsap.blogspot.com
On Tue, Apr 14, 2009 at 11:27 AM, Jared Still <jkstill@xxxxxxxxx> wrote:
On Tue, Apr 14, 2009 at 7:12 AM, Dba DBA <oracledbaquestions@xxxxxxxxx>
wrote:
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: http://awads.net/wp/
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.'
This email was received from the INTERNET and scanned by the Government
Secure Intranet anti-virus service supplied by Cable&Wireless in
partnership with MessageLabs. (CCTM Certificate Number 2007/11/0032.) In
case of problems, please call your organisation?s IT Helpdesk.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
For the latest data on the economy and society consult National Statistics at
http://www.statistics.gov.uk
*********************************************************************************
Please Note: Incoming and outgoing email messages are routinely monitored for
compliance with our policy on the use of electronic communications
*********************************************************************************
Legal Disclaimer : Any views expressed by the sender of this message are not
necessarily those of the Office for National Statistics
*********************************************************************************
The original of this email was scanned for viruses by the Government Secure
Intranet virus scanning service supplied by Cable&Wireless in partnership with
MessageLabs. (CCTM Certificate Number 2007/11/0032.) On leaving the GSi this
email was certified virus free.
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
Other related posts:
