Alternatives to SQL *Plus

[Ant]

Hi,

I have an SQL assignment to do and at my school we use SQL *Plus there
however I don't have Oracle at home, where I would like to do the work ,so I
was wondering whats the easiest way to get an SQL environment up so I can
code in that then just paste it into SQL *Plus later.

I don't really want to install Oracle on my home pc and I was wondering if
there are other IDE's for SQl that would fit my need for this.

I discovered an instant SQL *Plus client that sounded really promising but
when i unpacked it, it was just a load of dll's so I think it wasn't what I
thought it was.

So does anyone know of anything that might be able to help me out here?

Any advice much appreciated!

Thanks
--
Ant

[Enoch]

Ant wrote:

Hi,

I have an SQL assignment to do and at my school we use SQL *Plus there
however I don't have Oracle at home, where I would like to do the work ,so I
was wondering whats the easiest way to get an SQL environment up so I can
code in that then just paste it into SQL *Plus later.

I don't really want to install Oracle on my home pc and I was wondering if
there are other IDE's for SQl that would fit my need for this.

I discovered an instant SQL *Plus client that sounded really promising but
when i unpacked it, it was just a load of dll's so I think it wasn't what I
thought it was.

So does anyone know of anything that might be able to help me out here?

Any advice much appreciated!

Thanks
--
Ant

It sounds like you only downloaded the initial 30meg basic package, you
*also* need to download the additional SQL*Plus zip file, which is tiny,
less then a meg.

http://www.databasejournal.com/featu...le.php/3371561

For how to set it up, you'll need to create a tnsnames.ora file, just
search the oracle directory at your school for the file and copy that
one if you can't create your own. The URL given has details of how to
connect by IP too.

Also your uni could quite well have the web based isql*Plus form/app
installed.
I think the default location would be along the lines of:
http://oracleName.yourUni.tld:4443/isqlplus
but I'm sure they can tell you.

Enoch.

[Mark C. Stock]

"Enoch" <En***@theFort.org> wrote in message
news:2c********************@giganews.com...

Ant wrote:

Hi,

I have an SQL assignment to do and at my school we use SQL *Plus there
however I don't have Oracle at home, where I would like to do the work
,so I
was wondering whats the easiest way to get an SQL environment up so I can
code in that then just paste it into SQL *Plus later.

I don't really want to install Oracle on my home pc and I was wondering
if
there are other IDE's for SQl that would fit my need for this.

I discovered an instant SQL *Plus client that sounded really promising
but
when i unpacked it, it was just a load of dll's so I think it wasn't what
I
thought it was.

So does anyone know of anything that might be able to help me out here?

Any advice much appreciated!

Thanks
--
Ant

It sounds like you only downloaded the initial 30meg basic package, you
*also* need to download the additional SQL*Plus zip file, which is tiny,
less then a meg.

http://www.databasejournal.com/featu...le.php/3371561

For how to set it up, you'll need to create a tnsnames.ora file, just
search the oracle directory at your school for the file and copy that one
if you can't create your own. The URL given has details of how to connect
by IP too.

Also your uni could quite well have the web based isql*Plus form/app
installed.
I think the default location would be along the lines of:
http://oracleName.yourUni.tld:4443/isqlplus
but I'm sure they can tell you.

Enoch.

you can request an HTMLDB account from Oracle http://htmldb.oracle.com

this will include SQL Workshop which has a SQL Command Processor, so you
can
try out just about any SQL statement you like (but not SQL*Plus commands)

++ mcs