Category Archives: programming

INSERT and Error Logging

I have come up to this feature of Oracle lately, when I was working on a certain script to insert and merge data from various tables into one, and was looking out for an effective way to record the errors … Continue reading

Posted in database, Oracle, Oracle DBA, programming | Leave a comment

Oracle CBO :: Different Predicates, Same Execution Plan

There are some unfortunate and rare situations which I encounter on few misfortune days of my career, whose investigations lead me to new theories and discoveries. While internet becoming so much information rich these days that it becomes quite easy … Continue reading

Posted in Computers, Oracle, Oracle DBA, Oracle Performance Tuning, programming, scripting, technology | Tagged , , , , , , , | Leave a comment

A cool piece of PL/SQL – Spelling out a number in Oracle !!

Unlike the usual posts of mine, this one would be related to one interesting beauty of code I learnt today while I was investigating on Google for a “quick” solution to one interesting issue in Oracle at my work-place. This … Continue reading

Posted in Computers, database, Oracle, PL/SQL, programming, Tom Kyte | Leave a comment