Re: A better SQL*Plus -- what features should it have?

From: toolsguy <no_at_spam.for.me>
Date: 7 Nov 2002 10:03:21 -0800
Message-ID: <aqe9t9022ap_at_drn.newsguy.com>


[Quoted] In article <aqe4hh$8jg6l$1_at_ID-86071.news.dfncis.de>, Matthias says...
>
>toolsguy wrote:
>> I am developing a "better SQL*Plus". What features do you expect from a
>> better SQL*Plus?
>>
>> Up-arrow to bring back commands from history is an obvious feature that
>> is sorely missing in SQL*Plus. What else?
>>
>avoid using tnsnames.ora
>
>i think it is undocumented but it worked from oracle 7 on (even earlier
>?? - since SQL*Net 2 - i don't know exactly) that u don't need a
>tnsnames.ora
>instead using the alias specified there u can use the right hand-side of
>it in a (single line) string
>

That's easy. You will be able to just enter host, port and SID and I will generate that nasty parentesized string for you behind the scenes. There will ne no need for a tnsnames.ora. I will also remember all the host:port:sid that you typed in the last 1 month, so you won't have to remember anything.

By the way, which SQL*Plus commands do you feel are the most important? DESCRIBE is a SQL*Plus command, and is obviously important, but what else?

SQL*Plus allows you to type multi-line statements (for example, PL/SQL snippets). Is this ability important? Anyone using it? (Supporting this will be a problem if I am also going to support up-arrow.) Received on Thu Nov 07 2002 - 19:03:21 CET

Original text of this message