Re: Frustrated SQL Plus user

"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message news:sjmcbn2s5ri103_at_corp.supernews.com...
> "dizzy" <dizzy73_at_connix.com> wrote in message
> news:393AD7F3.54104117_at_connix.com...
> >Yes you're rite, that's what it was. So in that case I nave notepad
 popping up
> and closing every 5 minutes not to mention I then have to name and
 remember my
> past queries.. I thought that's what computers we for! ;-)
 

> >Haven't you used sql worksheet? My primary problem is I don't have a
 machine
> here (home) with enough resources to act as a server. If you have Oracle
 on an
> nt server chances are worksheet is available.
>
> We have Oracle running on DG/UX Unix at work. Now that I think about it I
> might have seen SQL Worksheet available at some point but I've no idea how
 to
> use it or what to use it for.

I use SQL Worksheet as a replacement for SQL-PLUS. It has a split display where you type on the bottom and the results appear at the top. It has a browser-like command history and lets you save your SQL to files. It is very easy to edit statements because you can use the arrows to move around, and you can scroll your commands independently of the output results. It also lets you type in nicely-formatted multiline SQL statements. Just remember that to send the command you must type CTRL+ENTER, since ENTER by itself just inserts a blank line. I don't think SQL Worksheet comes with Developer, but I installed it with Enterprise Manager. I don't know if SQL-PLUS has any benefits over SQL Worksheet since i've never had to use SQL-PLUS.

• Brian