Re: Frustrated SQL Plus user

"Matt B." wrote:
>
> "dizzy" <dizzy73_at_connix.com> wrote in message
> news:393A9546.A0098374_at_connix.com...
> > well, if I envoke the editor it seems to interfer with the sql+ window both
> dont like to be open at the same time. To me thats an unacceptable "workaround"
> heck it dosnt work on my system!
>
> I think that's because the SQL*Plus window is "waiting" for you to close the
> editor window (probably Notepad) because you are modifying the same data
> (script) that's in the buffer.

[Quoted] 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!
;-)

[Quoted] [Quoted] 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. Ive you're client is on an nt server type in vaw in the run box. Its a *much* better tool than +

>
> >I really dont see why sql+ is in such high regard. Imo its a horrible tool
>
> I agree that the things you found that you don't like can be annoying. I
> didn't know that SQL*Plus is really held in any "high regard" though - I just
> figured it was the basic no-frills user interface between you and the database.

Many of the books and people here speak well of + as if it were a high end tool. I figured either I was missing something and there must be some keyboard keys that actually did something, or this was a common complaint and someone wrote a + type replacement. Actually Im in the middle of a vb. interface utility that would do this... but I wanted to start querying my tables with a 1/2 way decent tool. Apparently + is it.

Is this not a common complaint? Heck.. my program may be needed!
>
> However, it does have some rather nice formatting capability in terms of
> formatting output into a report-like format. On client-server machine it's
> probably not all that impressive (there are probably other tools that do it
> better) but if you're in character-based UNIX it's pretty cool (sutotaling
> numbers, titles, page numbers, column headings, etc.). The various formatting
> commands (linesize, heading, pagesize, ttitle, btitle, sql.pno, etc.) are
> simple enough that someone who is moderately proficient with SQL*Plus and not a
> full-on programmer can still do it. You can also use all those settings to
> spool out data to a file for data conversion or something like that (no
> headings, no page breaks, fixed-length or delimited, etc.).

No doubt, personally we (at work) do high end reports with crystal. I actually don't work with the reports, hence I have no appreciation for those features. Im looking for a basic tool to query the database, one that can save all the session queries in a buffer and allows me to left arrow into a statement to make changes.

>
> I guess what I'm saying is that SQL*Plus has it's place, isn't a total P.O.S.,
> but does have its limits and isn't an all-encompassing answer to the "What's
> the best user interface to an Oracle DB?" question.

Well its definitely not + and what shocks me most is Oracle Corp dosnt invest any development on it. They do have worksheet which works well, but for personal Oracle.... Im doomed to + In fact Ive seen the Java based worksheet on 8i and the program had serious problems. The new java based programs needs client machines which an extremely high processor just to run the editor!

From someone who is accustomed to sql worksheet, + is a last resort pos
>
> Anyway, T.O.A.D. is pretty popular at work - you might wanna download a free
> trial version of that from http://www.toadsoft.com. Not sure if it stores
> queries in a buffer historically (like, say, the last six queries you did) or
> not, but give it a shot and see how you like it. It has an OK SQL window plus
> lots of other tools, like extracting the code from stored DB objects (packages,
> procedures, functions, etc.) fairly easily.
>
> We've also used SQL Station before too (I think Platinum Technologies make
> that). I haven't used it though so I can't vouch for its effectiveness.

[Quoted] Thanks for your input Matt. Im really surprised there isn't an alternative to +
If my vb. utility ever gets finished (probably 3 months) Id certainly make it available for download.

Best Regards
rob Received on Sun Jun 04 2000 - 00:00:00 CEST