Blog

Oracle XML Nested Elements

I recently encountered a request to generate XML in one select query in Oracle to ...
Oracle

Oracle Sequence Skipping Numbers

Ever wonder why there are missing numbers when you get the NEXTVAL of the oracle ...
Blog

SQLLDR - Error Field in data file exceeds maximum length

One of our migration consultants is asking our Siebel Administrator as to why his sqlldr ...
Uncategorized

Ora Error ORA-01422 - Exact Fetch Return More Than One

I got the error below recently and it's quite new to me. One of the ...
Blog

Install jpegoptim in CentOS

If you're an adsense publisher, you might have noticed the scorecard the middle-right side of ...