Sergio's Blog

Another One From the Archives: Easy Connection Identifier

By sergio.leunissen on March 10, 2009 1:30 PM

My good friend Joel showed me how you can connect to a (remote) database using an easy connect identifier. Here's how it works: sqlplus sergiodb/sergiodb@//127.0.0.1:1521/mvl It looks to be a way of constructing a connect identifier that's new since...

Comments (1) | TrackBacks (0)

Installing Required RPMs from DVD Before You Install Oracle Database 10g or 11g

By sergio.leunissen on February 17, 2009 6:42 AM

I came across a forum post in which one of my co-workers, Avi Miller, explained how to install Oracle Enterprise Linux from DVD so that all software requirements are met when you fire up the Oracle Database 10g or...

Comments (9) | TrackBacks (0)

Quick and Dirty Inline Charts and RATIO_TO_REPORT

By sergio.leunissen on October 24, 2008 7:54 AM

Another post from the archives... HTML Expressions is a feature in the Application Express reporting engine that lets you apply an HTML mask to a column value in a report. In the HTML Expression, you refer to the column...

Comments (3) | TrackBacks (0)

Search Through Region Source in Application Express

By sergio.leunissen on September 30, 2008 2:46 PM

As I was working to migrate an application and its theme over to Application Express 3.1.2 from 2.1.2 I needed to move some images around and update the references accordingly. I remembered that the Application Builder has a feature...

Comments (0) | TrackBacks (0)

oracle-validated RPM also available on Oracle Enterprise Linux 5 Update 2 media

By sergio.leunissen on September 11, 2008 5:23 AM

In the comments on my previous post on the Oracle validated RPM, Frank points out that this RPM is also available on the Oracle Enterprise Linux 5 installation media, starting with Update 2. You can download Oracle Enterprise Linux from...

Comments (0) | TrackBacks (1)

cx_Oracle and DBMS_APPLICATION_INFO

By sergio.leunissen on August 29, 2008 10:51 AM

Here's another post from the old blog, harvested from archive.org The other day I was playing with some Python and cx_Oracle, a Python module for connecting to Oracle databases. While cx_Oracle seems to work great, I found the documentation light...

Comments (0) | TrackBacks (0)