dave's blog

SQLPLUS and the Ant build tool...

I've been looking for ways to automate running of Oracle SQLPlus PL/SQL scripts.Of course there are always batch and shell scripts but I'm looking for something less OS specific.Our Java build process is controlled by Apache Ant. It would be nice to include running of SQL scripts in this process. Here are some tools to help integrate SQLPLUS with ANT.

SQL Task
This task is best for executing bits of literal SQL. This task doesn't know anything about SQLPlus features such as formatting, variables, spooling, etc.


1ZO-031 down, two to go…

So I'm 60% of the way to my 9i OCP now. I passed 1ZO-031 today. I already had the 1ZO-007 test and a hands-on class under my belt.

So far I've been using the Certification Candidate Guide, Oracle Press books and of course the Oracle documentation. For my next two exams I got some Sybex books cheap off of Amazon.com that I'll be checking out.


Software blast from the past…

Ever smell something that brings back a memory from way long ago?

I had the same sort of experience today but it was because I saw a software display screen.

I was in a popular discount store in the Southeast US today and the cashier was having some problems ringing up my order. I checked out the screen and saw a software program that I worked on 10 years ago. I used to work for a Point of Sale software company and we developed a custom POS software package for this client.


Tim Bunce on the future of Perl DBI

PerlCast.COM has posted a interview with Tim Bunce available here.

Audio is here: http://www.perlcast.com/audio/Perlcast_Interview_038.mp3

– Dave


Like the v$session_longops progress bar in OEM? You'll love this…

One of the redeeming qualities of the Java Oracle Enterprise Manager client is the progress bar that comes up when you are viewing the long operations of a session. I wanted this functionality but didn’t want to wake up the big lug to get this info (it takes a long time to start up the OEM client and navigate to the screen to see the long operations progress bar).

So I decided to write a short script to emulate that functionality but take it one step further and show me info about _all_ the longops currently running on an instance.

otop , a 'top' utility for Oracle

I recently discovered that someone else is publishing some Perl utilities to monitor Oracle!

I've been using Perl to get things done with Oracle for a while and have found it extremely helpful. The current environment that I work in has a mixture of OSes so sometimes its easier to install Perl and DBI everywhere and write a simple Perl Script than to try to do something in DOS Batch for one client and then do it again in a bash shell script for another.

Sean Hull published a video of his talk about otop, the PowerPoint slides, and the downloadable source on his company's site:

WAMP - ing

Windows / Apache / MySQL / Php.

This is a diversion from my usual immersion in all things Oracle. Along with my blog at http://www.ba6.us I've got a handful of sites that are quick and dirty custom webapps that I host on BlueHost.com. BlueHost, like many consumer level web hosts offers Apache, MySQL, and Php on the cheap.

I wanted an environment I could use for development and experimentation. Here is how to set up a simple dev environment for Apache / MySQL / Php on a Windows machine…

1) Windows

I'm not going to cover installation of Windows here.

Oracle imp utility COMMIT parameter and LOBS…

If you have a lot of LOB data to move around with Oracle import/export utilities this might help you out. The default for the COMMIT parameter is No.

COMMIT=N : For tables that have a LOB column, commit is performed after loading each table
This is much faster but be aware that you will use more Rollback space since each table will be committed in one large transaction.

COMMIT=Y : For tables that have a LOB column, commit is performed after each row (slow!, much overhead added because so many transactions are used to import the data)

Using SQLPLUS to generate scripts…

Tired of updating scripts by searching and replacing until your fingers fall off? Have a SQL statement you have to run against every table in your schema?

Next to Regular Expressions, this is one of the most useful tools in my arsenal.

Common uses for this are to write SQL statements that can work from a list of objects in the database:


Subscribe to RSS - dave's blog