5 Interesting Things You May Have Missed On This Aug 16, 2010

Use The Index, Luke

A guide to database performance for developers
VoraX

A simple, yet a powerful IDE for Oracle databases. Instead of reinventing the wheel, VoraX relies on the well-known SqlPLUS which is actually used to connect to the database, to execute and to get the results back. However, this interaction is hidden from the user who just uses his/her Vim environment without knowing that, behind, a SqlPLUS process does all the work.
Analytic Top-N Queries

Different ways to write Top-N SQL and the performance implication of each.
Working with LONG columns

Various techniques for querying and manipulating LONG columns.
Creating a Database link without adding an entry to the tnsnames.org file

Different ways to create a database link.

Filed in Interesting Stuff on 16 Aug 10

Comments are closed.