OracleBlog

PL/SQL vs J2EE, Part 2

I knew there was going to be some discussion following up my previous post on using stored procedures instead of embedding SQL in your J2EE application. Some of it you can read in the comments, others you can find on other people's blogs.

Original Article
Tim Hall's Response (and Here).
Harry Boswell's Response
Dizwell Discussion: Database Independence

I also saw a similar discussion that had taken place over a year ago. Check out these posts by Mark Rittman and Dave Warnock for a Point-Counterpoint on the debate.

Mark Rittman
Dave Warnock's Response

Gary Myers and Harold Ramis Separated At Birth


Gary Myers

Harold Ramis

In seriousness, I've enjoyed Gary Myers' blog for quite some time, but I particularly enjoyed his recent series of blogs on the 12 SELECTs of Christmas, so I thought I would highlight it for you to enjoy again.
12 Selects of Christmas, Part I
12 Selects of Christmas, Part II
12 Selects of Christmas, Part III
12 Selects of Christmas, Part IV

Neat Tricks

Some time ago I posted an article on UTL_HTTP that gave Pete Finnigan a security-related heart attack. Just when he was recovering, Doug Burns posted a neat little trick that will give him another stroke. Apparently within SQL*Plus you can execute an SQL script somewhere on the Internet. Try it!

UTL_HTTP Post
Pete Finnigan
Doug Burns

Blog Updates

I've noticed Tony Andrews, whose blog I quoted in my last post, has some new content including an interesting So Doku Solver in PL/SQL. Check it out here, and hope he continues to post:
Tony Andrews PL/SQL So Doku Solver

Another new Oracle blog to check out is Yas'. I've enjoyed several of his postings recently, so its hard to pick just one to highlight, but given its similarity to my recent post on Bulk Binding and FORALL, here is one on BULK COLLECT.
My FORALL
Yas' BULK COLLECT

Ask Tom

I spend a fair bit of my Oracle web-surfing time over on AskTom. If you ask many of us, we'll say its an invaluable source of information, and also houses some very interesting discussions. Here are three samples of discussions I've been following recently.

Driving Tables
Introduction to Analytical Functions
Batch Processing

Old Post Updates

The original intention of this blog was to have a place to organise my thoughts on things that I have learned about Oracle. Therefore, generally a post here is merely one of the early stages of my exploration on a particular topic. I usually continue my exploration, and doubtlessly continue to find interesting articles on the same topics. Here are two examples.

You may have noticed that I talk a lot about NULL, how funny it is, and how misunderstandings lead to errors. I mentioned recently that if I were to write an article it would probably be about NULLs. I was flipping through an Oracle magazine I had missed from last Summer and saw that Lex de Haan and Jonathan Gennick had beaten me to it.
Nulls: Nothing to Worry About

Last Fall I blogged on using ROWNUM and ROWID, and I just recently found an awesome post on AMIS to demonstrate the power of using ROWNUM to improve performance.
Original Post on ROWNUM
Alex Nuijten on ROWNUM

Finally

My final order of business is related to Oracle only in that it involves one of our favourite PL/SQL experts, Steven Feuerstein. Steven recently started a personal blog, and even posted an article in response to a questionable comment I left on Eddie's Blog.

Eddie Awad
Steven Feuerstein is a nut?

But rather than talk about nuts, I would really like to highlight just how much Steven Feuerstein's work has helped me, and how it can help others. You can see my blog is littered with examples, here is another, about how to hide your code:

Steven Feuerstein Q&A: Hiding PL/SQL
My Article about Steven Feuerstein on Refactoring