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)

Installing oracle-validated from an Oracle Enterprise Linux DVD using yum

By sergio.leunissen on October 22, 2008 1:10 PM

In an earlier post, I mentioned that the Enterprise Linux 5 Update 2 installation media have the oracle-validated RPM on it. The same is true for the Enterprise Linux 4 Update 7 media. If you don't have access to...

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)