Who you are supposed to be ?

You are a geek ...

You are an integrator or architect ...

You are lost in *nix OS, and forgot how to use m$ windows ...

You are in forced to deal with Big Head Oracle ...

You are jealous that people in m$ windows world easily diggin' to Oracle database using TOAD ...

and you are a handsome guy that using bloody Debian Squeeze !!!

So if you are all of that, lets continue.

Prerequisites

Install the oracle instance client on your Squeeze, take a look on my article "Oracle Instance Client @ Debian Squeeze"

# apt-get install cmake cdbs qt4-qmake libqt4-dev libqscintilla2-dev
# cd /tmp
# apt-get source tora

Build and Install

Get the oracle include path and oracle home path of

What is it ?

My intention is to help you people debian bloody user to put a connection client of oracle instance client for your own work. But some prerequisite need to be installed first.

If you're still have some interest on this subject, so let's continue.

Prerequisites

Get the oracle-instantclient11.1-basiclite-11.1.0.7.0-1.i386.rpm, oracle-instantclient11.1-devel-11.1.0.7.0-1.i386.rpm, and oracle-instantclient11.1-sqlplus-11.1.0.7.0-1.i386.rpm from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/...

# apt-get install libaio1 alien

Then install the client that previously we download

# alien -i oracle-instantclient11.1-basiclite-11.1.0.7.0-1.i386.rpm
# alien -i oracle-instantclient11.1-devel-11.1.0.7.0-1.i386.rpm
# alien -i oracle-instantclient11.1-sqlplus-11.1.0.7.0-1.i386.rpm

Find the library path of

Tables

Creating Tables

Oracle data is stored in tables which represent your fundamental schema design. You create them with the create table command:

create table tablename ( columnname type, columnname type ...);

where tablename is the name of your table, columnname is the name of your column and type is the type as specified in the table below. There are additional types available, however these are the most common. Give some thought as to the order of columns as it can effect the default order they are displayed and data is entered. 

Observing Table Information

The easiest way to get information