Re: A better SQL*Plus -- what features should it have?
Date: 8 Nov 2002 08:23:32 -0800
Message-ID: <aqgoe401lum_at_drn.newsguy.com>
In article <kpinsuk5c1foduh9vi82e5nn2c4ss8gm4s_at_4ax.com>, TurkBear says...
>
>
>This gains you what, exactly ?
>
>You would rather type something that like this:
>
>connect scott/tiger_at_(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =
>myhost)(PORT = 1521)) ) (CONNECT_DATA = (SID =
>mysid))
>
>all the while counting parens to be sure they match,
>
>instead of
>connect scot/tiger_at_mydb
>
>
>Using tnsnames.ora ( unless it is very, very, very large does not impose any
>performance penalties, so why not use it?
>
>
How about typing this instead:
connect scott/tiger_at_myhost:1521:mysid
Internally my program will generate that connect string with parens.
The advantage is that in order to connect to a new database you don't have to first make an entry in tnsnames.ora Received on Fri Nov 08 2002 - 17:23:32 CET