Skip to content

Category Archives: PL/SQL

PLSQL: 11g datatypes for performance

I just got a tip regarding an article about new datatypes possibly increasing PL/SQL performance in 11g (Thank you Patrick). Here is the article: http://www.confio.com/logicalread/performance-improvements-with-oracle-11g-data-types/#.UnjEqBD-5Ag

Posted 07 November 2013 † Lasse Jenssen § 11g New Feature § DBA § Performance ‡ Comments (0) °

Article: Faster Batch Processing and Logging by Mark rittman

I just read this article about efficient error handling when running batch jobs. This is somethink many DBAs and developers should put on their mind, and consider using next time they’re planning to do dataloads or batch jobs.

Posted 20 November 2012 † Lasse Jenssen § 10g New Features § DBA § SQL ‡ Comments (0) °

PL/SQL: Nice article by Feuerstein about the use of packages

In this article Feuerstein explains why, when and how to use packages. He also explains when stand alone functions and procedures might be preferred.

Posted 14 November 2012 † Lasse Jenssen § Oracle ‡ Comments (0) °

PLSQL: Exception Types

Knowing how and when to handle exceptions is crutial when writing PLSQL (as in most other programming languges). This does not mean that you always should handle your exceptions in your PLSQL code. Most probably you shouldn’t, or at least not all of it. Handling exceptions in PLSQL is more about “securing a consistent state […]

Posted 18 August 2012 † Lasse Jenssen § Oracle ‡ Comments (0) °

PLSQL: Naming convention

I really appreciate PLSQL code with some kind of naming convention. I try to stick to these conventions by Steven Feuerstein.

Posted 16 July 2012 † Lasse Jenssen § Oracle ‡ Comments (0) ° Tagged:

PLSQL: Inserting And Updating Using Records

One feature I very seldom see in use is the possibility to insert and update data using Oracle records. A record is a composite datatype having the capability of holding more than one single value all with possible different datatypes. If the number of attributes within a record is the same as in a table […]

Posted 15 June 2012 † Lasse Jenssen § Oracle ‡ Comments (0) °

10g SQL: MEMBER OF statement … but watch out

In 10g Oracle introduced the MEMBER OFF statement. The following article shows how using this feature handling binding in-list may introduce performance degradiation. The article also show an example where the feature increase performance. Once again: There is very few universal rules regarding SQL tuning.

Posted 09 January 2012 † Lasse Jenssen § Oracle § SQL ‡ Comments (0) °

PL/SQL: Missing ELSE in CASE-statement

What happens if we miss out the ELSE in a CASE statement? If your answer is “nothing”, then you might be up for a surprise. If we don´t include an ELSE-statement in a IF-statement, and the boolean expression evolves to false, then you´re completly right – nothing happens! The code will continue running after the […]

Posted 02 January 2012 † Lasse Jenssen § Oracle ‡ Comments (0) °