Oracle

SQL*Plus variables – Oracle Next ID Number without a Database Sequence

Traditionally the mechanism to retrieve near sequential numbers for the purposes of a database table PK is to use a database sequence. Occasionally ...Read more

Oracle SQL – Querying columns containing CSV ID’s

Data modellers, developers, and purists all hate it when multiple ID values are stored in a single database column value. Data modellers hate ...Read more

Junk DNA – Junk Oracle, part 0000003 …. DROP TABLE IF EXISTS

Almost every week I write or enhance software components that are deployed into a PROD environment. Every week, the full-fat versions of the ...Read more

Oracle, the gift that keeps on giving

When using Oracle I sigh often (from the perspective of a database developer). Oracle have, by design, implemented instability into their execution plan costings. ...Read more

ORDER BY “I am Desperate” DESCENDING

When an SQL result-set needs to be returned in some sort of order, it is not unreasonable to expect that the information to ...Read more

Finding Nemo Onetangi

Being a freelance contractor is often stressful - parachuted into a budget constrained project with tight timeframes and where you know next to ...Read more

Database Table Partitioning – Why?

There are not two common reasons why RDBMS DBA's partition database tables, but five. The two rote answer reasons usually cited for implementing ...Read more

There are times when I think Oracle is not for the experienced hand and that I have lost my touch

Why do I keep falling into the same man traps? Why can I not learn? Why do I put myself through the same debugging exercise ...Read more

Multibit Variable Width Encoded Datatypes – Questions To Myself

As some errors made by programmers are so blindingly obvious, you do not need to check whether the code would even, for example, compile! ...Read more

8, 9, 10, 11, 12, 17 – Of course!

I am likely to be proved wrong. Last year I blogged that the next major version of Oracle might be version 13. It is not an unreasonable ...Read more