RE: Do programmers tune SQL?

Thanks to everyone that replied to this question. I feel that I have a MUCH more well-rounded view of how this works at other organizations, and where the pitfalls are. I am going to develop a document for the developers that outlines how I see this working. I will share it with the list when I complete it. Thanks again.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, April 01, 2002 7:48 PM
To: Multiple recipients of list ORACLE-L

There was one guy at a site I used to work for that was interesting. He wrote his own shell scripts and PL/SQL routines and did them well. He was open to learning and all that good stuff. However, he felt that it was the sys. admin's job to write the shell scripts and the DBA's to write the PL/SQL (not the SQL). Its like ya, you want me to write your Java and C code also? Just a funny mix....

-----Original Message-----
Faroult
Sent: Monday, April 01, 2002 7:18 AM
To: Multiple recipients of list ORACLE-L

Rachel Carmichael wrote:

> My last shop we had one programmer who not only expected me to tune his
> SQL, he expected me to WRITE his SQL for me. I got emails "I need a
> query that returns this information from these tables".

This guy seems to be trying a new tactic these days: DBA mailing lists.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kimberly Smith
  INET: ksmith2_at_myfirstlink.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).