By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,946 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,946 IT Pros & Developers. It's quick & easy.

Alternatives to SQL *Plus

P: n/a
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

Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Jul 19 '05 #2

P: n/a

"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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.