DB – So, what’s a Transaction?

I posted a Gotcha in Oracle Commit some time back. This is one of the posts that gets visited a lot. Also, at work, I saw some SQL scripts that showed a complete lack of understanding of how transactions or commits work in Oracle (or any database for that matter). Hence this post. Dictionary.com defines Transact as […]

Rate this:

Gotcha: UPDATE in Oracle PL/SQL

A friend asked me why his stored procedure wasn’t working. He was calling it from a program, so there was no way to test it, other than saying the update didn’t happen. I looked at this procedure, it had one UPDATE statement. The meat of the code is shown below (I am paraphrasing): CREATE OR […]

Rate this:

Oracle Sequences contd…

​We are currently in the process of upgrading our Oracle database from version 11g to 12c. There are lot of challenges. One of the challenge we have is of course space. We have one test (Unix) machine that is running several Oracle instances. During the Oracle 12c, the DBA decided to upgrade only one of […]

Rate this:

Oracle Pivot Operator

While working on complex reports, we occasionally have a need to transform Columns to Rows and vice versa. Converting Rows to Columns is typically called Pivot and the opposite, converting Columns to Rows is called Unpivot. Concept of Pivot, and the need for it, has been around for a long time. Excel for example, has […]

Rate this:

Gotcha: Oracle Sequences – Contd…

I just posted an error some developers got while inserting records into an Oracle table. I assumed there was an issue with Sequence used and replied back. I included that in my last post here. I did receive a feedback after a week or 2. What I saw told me the developer did not have […]

Rate this:

Gotcha: Oracle Sequences – 1

I just posted about Oracle Sequences here. The very reason I posted was because, I’ve seen several experienced developers seem to fumble on it. We had one at work today. I recently got a request from our DBA to look at an error message from another group. (I’ve changed the table name etc to employee) […]

Rate this:

Oracle Sequences

Oracle Sequences are a unique animal. This seems to get a lot of developers. We had one issue at work today. I will post that separately. If you come from other databases, you are probably used to Auto Incrementing columns. Oracle does not have that. Short of that, it has a Sequence. A Sequence is […]

Rate this: