Oracle-L: Re: sql & isql

From: KENNETH JANUSZ <kjanusz_at_att.net>
Date: Wed, 17 Apr 2002 05:58:25 -0800
Message-ID: <F001.004465D3.20020417055825@fatcity.com>

You can also go to this site and download a88826.pdf - iSQL*Plus User Guide and Reference.

http://download-west.oracle.com/otndoc/oracle9i/901_doc/nav/docindex.htm

Ken Janusz, CPIM

Original Message ----- From: Ora NT DBA To: Multiple recipients of list ORACLE-L Sent: Wednesday, April 17, 2002 8:13 AM Subject: 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 isalso a topic of OCP 9i Exam-1. Would you please suggest some links where Ican get material in detail.Thanksmks                                                                                              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 basicallya web form that allows the user to type sql or sqlplus commands in thetop window andsee the results in the bottom window.  It is clusser to sql*plusworksheet than the conventionalsql*plus command line or gui.JohnDWILLIAMS_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 WilliamsDBALifetouch, Inc.dwilliams_at_lifetouch.comA word about the isql toolThe database access tool provided with Microsoft SQL Server is Microsoftisql. You must use Microsoft isql (or a compatible tool) to access theMicrosoft 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 samecomputer, 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 AMTo: Multiple recipients of list ORACLE-LDear Gurus,Where can I get the difference between 'sql' and 'isql' in Oracle. Ishall 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@netscape.netFat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing Lists--------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail messageto: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: KENNETH JANUSZ
INET: kjanusz_at_att.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). Received on Wed Apr 17 2002 - 08:58:25 CDT