Re: Frustrated SQL Plus user

From: Mike Dwyer <dwyermj_at_co,larimer.co.us>
Date: 2000/06/05
Message-ID: <luR_4.7$m22.692_at_wdc-read-01.qwest.net>#1/1


[Quoted] I learned to use SQL*Plus with Oracle v4, only back then it was called UFI - for User-Friendly Interface.

We called it, "FUI"!

[Quoted] So Oracle changed the name of the product.

The product has hardly changed at all in 12 years. (And Oracle still changes product names, too.)

SQL*Plus is still my favorite interface, in spite of having TOAD just as handy. Some habits never die. But it isn't the right tool for every job; no tool is.

"TurkBear" <johng_at_mm.com> wrote in message news:393bb702.3154075_at_news.news-ituk.to...
>
> Hi Diz,
> relax...SqlPlus is not designed, really, for serious programming with any
 real
> debugging features, so you need to use something like PL/Sql developer, or
> T.O.A.D. or SqlNavigator ( last 2 are from www.quests.com ) - however,
> do not overlook the 'list' command in SqlPLus...
>
> With this you can recall the last submitted Sql code, and by using the
> c/oldvalue/newvalue construct in conjunction with the line number to
 edit it
> while it stays in the buffer...
>
> Read the SqlPlus manual and you may find it more useful than it first
 appears...
>
> Hope it helps,
>
> dizzy <dizzy73_at_connix.com> wrote:
>
> >Hi All
> > I've waited as long as possible to post here because I figured I must
> >be missing something, however after reading the documentation, searching
> >the archives of this list and searching online I've come to the
> >conclusion that SQL plus is too arcane for my use.
> >
> >The problem
> >
> >Im running personal Oracle 8.05 which apparently dosnt have sql
> >worksheet which Im accustomed to.
> >I don't like the fact that the past commands are not saved in a buffer
> >no use of the left arrow to modify a previous statement
> >
> >I think its insane to have to retype a command I previously typed while
> >in a session. Or have to copy and paste
> >The "tools" on the toolbar seem useless. I even find the documentation
> >for sql + insane.
> >"the semi colon is optional..." Well its either a semi colon or type
> >run after issuing the statement!
> >Im used to sql worksheet where I can execute the statement by pressing
> >ctrl+l
> >
> >Im looking for an simple editor/worksheet that will do the above. Is
> >that too much to ask? Is there such a program?
> >
> >Thanks for any pointers
> >
> >rob
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Mon Jun 05 2000 - 00:00:00 CEST

Original text of this message