Re: Partly OT - Database Programming textbook

From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Tue, 02 Apr 2013 09:34:49 -0600
Message-ID: <515AFA99.9080400_at_gmail.com>

On 02/04/2013 8:44 AM, John Hurley wrote:
> Everyone in the Oracle industry as far as I know ( hoping here! ) does understand the Tom Kyte mantra of "Do it in 1 SQL statement if you possibly can" before tackling stuff in cursors/procedures/etc!
> --

I absolutely love those consultants and developers who insists "SQL is SQL - there is no difference between Oracle , MySQL, SQL Server, etc."

It may be reasonably close for single isolated SQL statements, but no RDBMS I am aware of any more runs single SQL statements in total isolation. As a consultant, I make a fair decent living addressing what happens when you run two or more SQL statements against one database, and the developer has experience with another database and has converted, rather than ported.

I agree with the mantra: Be as lazy as possible, by

• using NO code, if possible (error/exception handling, rather than preface with 'select count')
• using a single SQL statement, and set manipulation, when possible
• if multiples are required, put 'em in a stored proc.
• then, and only then, consider remote code.

'Vendor independence' is something we smoked on the 90's - that has been debunked, economically, for years. ;-)

That said, I am looking forward to Stéphane's book. I have, and recommend in my classes, a number of his books.

/Hans

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 02 2013 - 17:34:49 CEST