Re: sql isql
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@netTo: Multiple recipients of scape.net list ORACLE-L Sent by: [EMAIL PROTECTED] root@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 [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: sql isql
9i provides iSQL*Plus browser based tool. Don't know if it is similar to these. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, April 16, 2002 9:18 AM 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. [EMAIL PROTECTED] 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: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: KENNETH JANUSZ INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: sql isql
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 [EMAIL PROTECTED] 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. [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).