Home

Recent Posts

Application Migration - Part 3

3 minute read

Ok, Finally, we have got to part 3 of Application Migration.  In Part 1, we outlined a program which runs in Sybase through iSQL.  We then followed this, in ...

Using History Keys in SQL*Plus

3 minute read

I was working through a bug the other day and using SQL*Plus, which for the most part doesn’t annoy me too much.  However, one of the things that does, is ha...

SQL Tuning Advisor - 101

3 minute read

The DBMS_SQLTUNE package is the interface for tuning SQL on demand. Its Doc pages are here.  Have a look.  There is a lot of stuff to do to set a tuning task...

Using Hierarchical Profiler in SQL Developer

3 minute read

One of the features exposed since SQL Developer 1.5 is the hierarchical profiler.  There have been several blogs and things about this but none I think that ...

Remote Debugging with SQL Developer revisited.

2 minute read

As part of the development process, we all have to work out the bugs in our code.  For all of us who use SQLDeveloper , we know how to debug with SQL Develop...

Continuous Integration for SQL Tasks

2 minute read

One of my favourite integration tools is hudson.   Today, we’re going to show you how to setup hudson on the Oracle Developer Day image.  Since the image is ...

Application Migration - Part 2

4 minute read

In our previous post, Application Migration -Part 1, we introduced application migration for change of database.  In the examples, we cited Sybase to Oracle....

Application Migration - Part 1

2 minute read

For the last couple of releases SQLDeveloper has added features which help our users analyze their applications.  Now, when I say analyze, I really just mean...