469,909 Members | 2,041 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,909 developers. It's quick & easy.

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

Jul 19 '05 #1
2 3872
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

"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.

Similar topics

12 posts views Thread by christopher diggins | last post: by
43 posts views Thread by Steven T. Hatton | last post: by
8 posts views Thread by | last post: by
4 posts views Thread by sunderjs | last post: by
2 posts views Thread by Ant | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.