Oracle: Delete all rows from all tables etc…

Quick method to do multiple actions across multiple tables. Simply spool a script with your commands in for each table – this way you can avoid...

Read More

Oracle: Update From equivalent

Quick note on how to update data in a series of joined tables using a subquery in the UPDATE statement in Oracle, kind of like the...

Read More

Changing the HTTP port Oracle uses

In a production environment your database server will be completely separate from your application server or at least it should be. So in theory you should...

Read More

Setting Database Connections in JBoss/ ATG

ATG communicates to a database via JBoss via a dynamo server setup or in your home/localconfig directory if you’re not using specific dynamo servers. In this...

Read More

Joining columns/ concatenate strings in Oracle PLSQL/ MySQL

Joining columns and results together is really easy in Oracle or MySQL, in both there is the same function – CONCAT(). However you should be aware...

Read More

Writing basic case switch statements in Oracle PL/SQL

This is the equivalent code for writing a switch statement in Oracle. In Oracle to do the switch we use a function called case. Which looks...

Read More

Spool a CSV file from Oracle/ SQL*Plus without quotes

Quite useful, I had the case where I needed to provide a CSV file to an external party from our Oracle 10g database. No problem, there...

Read More

LIMIT equivalent for Oracle

So you use MySQL etc… and you’re used to adding a LIMIT clause to your query for example, SELECT * FROM table WHERE name = ‘bob’...

Read More