Re: sql & isql

Hi Mks,

I went to http://tahiti.oracle.com selected on Oracle9i docs. And then searched on
iSQL*Plus. There is actually an iSQL*Plus users guide.

John

mkshrivastava_at_iffco.nic.in wrote:

>Dear DBAs,
>
>Yes I am referring to the iSQL*Plus tool available in Oracle9i. This is
>also a topic of OCP 9i Exam-1. Would you please suggest some links where I
>can get material in detail.
>
>Thanks
>mks
>
>
>
>
> Ora NT DBA
> <orantdba_at_net To: Multiple recipients of
> scape.net> list ORACLE-L
> Sent by: <ORACLE-L_at_fatcity.com>
> root_at_fatcity. cc:
> com Subject: Re: sql & isql
>
>
> 16/04/2002
> 08:33 PM
> Please
> respond to
> ORACLE-L
>
>
>
>
>
>
>Hi all,
>
>
>Mks is probably referring to the iSQL*Plus tool available in Oracle9i.
> This is basically
>a web form that allows the user to type sql or sqlplus commands in the
>top window and
>see the results in the bottom window. It is clusser to sql*plus
>worksheet than the conventional
>sql*plus command line or gui.
>
>John
>
>
>DWILLIAMS_at_LIFETOUCH.COM wrote:
>
>>Mks - "isql" is a Sybase and MS SQL tool, not Oracle. The following
>>
>excerpt
>
>>may clarify this. The equivalent in Oracle is probably SQL*Plus.
>>Dennis Williams
>>DBA
>>Lifetouch, Inc.
>>dwilliams_at_lifetouch.com
>>
>>
>>A word about the isql tool
>>The database access tool provided with Microsoft SQL Server is Microsoft
>>isql. You must use Microsoft isql (or a compatible tool) to access the
>>Microsoft SQL Server database to execute some of the test scripts
>>
>documented
>
>>in this Appendix.
>>
>>Although the name of the Microsoft isql tool is the same as the Sybase
>>
>tool
>
>>called isql, the Sybase and Microsoft tools are not compatible. For
>>
>example,
>
>>you cannot use the Sybase isql tool to access the Microsoft SQL Server
>>
>data
>
>>server and you cannot use the Microsoft isql tool to access the
>>
>Replication
>
>>Agent administration port.
>>
>>If you have both Sybase and Microsoft isql tools loaded on the same
>>computer, you may need to change an environment variable (possibly the
>>
>path
>
>>variable) to avoid problems when you invoke one of the isql tools.
>>
>>
>>-----Original Message-----
>>Sent: Tuesday, April 16, 2002 1:18 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>Dear Gurus,
>>
>>Where can I get the difference between 'sql' and 'isql' in Oracle. I
>>shall be grateful if anyone please mention some differences.
>>
>>mks
>>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ora NT DBA
> INET: orantdba_at_netscape.net
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ora NT DBA
  INET: orantdba_at_netscape.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).