From: "Brian Smith" Subject: Re: Frustrated SQL Plus user Date: 2000/06/05 Message-ID: <8hgq38$j90$1@flood.weeg.uiowa.edu>#1/1 References: <393A6B94.200DCF99@connix.com> <393A9546.A0098374@connix.com> <393AD7F3.54104117@connix.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Complaints-To: usenet@news.uiowa.edu X-Trace: flood.weeg.uiowa.edu 960228264 19744 129.255.38.92 (5 Jun 2000 18:04:24 GMT) Organization: The University of Iowa X-MSMail-Priority: Normal NNTP-Posting-Date: 5 Jun 2000 18:04:24 GMT Newsgroups: comp.databases.oracle.tools "Matt B." wrote in message news:sjmcbn2s5ri103@corp.supernews.com... > "dizzy" wrote in message > news:393AD7F3.54104117@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