📄 readme_sqlplus.htm
字号:
<!DOCTYPE html public "-//w3c//dtd html 4.0 transitional//en.us"><HTML lang="en.us"><HEAD><META NAME="Generator" CONTENT="Quadralay WebWorks Publisher Professional Edition 6.0.7"><META NAME="Page" CONTENT="Default"><META NAME="Title" CONTENT="SQL*Plus Release Notes"><TITLE>SQL*Plus Release Notes</TITLE> </HEAD> <BODY BGCOLOR="#ffffff"><A NAME="top"></A><A HREF="#BEGIN">Skip Headers</A><BR><BR><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR> <TD ALIGN="LEFT" VALIGN="TOP"><FONT COLOR="#330099" FACE="Helvetica, Arial, sans-serif"><STRONG>SQL*Plus Release Notes<BR>Release 9.2</STRONG><BR>Part Number A96545-01</FONT></TD><TD VALIGN="BOTTOM" ALIGN="RIGHT" WIDTH="144"><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"></TD></TR></TABLE></TD></TR></TABLE><HR><P> <A NAME="BEGIN"></A><DIV CLASS="IND"><!-- End Header --><A NAME="741061"></A><H1 CLASS="ProductTitle"><FONT FACE="Arial, Helvetica, sans-serif">SQL*Plus</FONT></H1><P><A NAME="743497"></A><SPAN CLASS="BookTitle"><FONT FACE="Arial, Helvetica, sans-serif">Release Notes</FONT></SPAN><P><A NAME="998710"></A><SPAN CLASS="VersionNumber"><FONT FACE="Arial, Helvetica, sans-serif">Release 9.2</FONT></SPAN><A NAME="998711"></A><SPAN CLASS="Platform"><FONT FACE="Arial, Helvetica, sans-serif"></FONT></SPAN></P><A NAME="998715"></A><P CLASS="PrintDate"><FONT FACE="Arial, Helvetica, sans-serif" SIZE="-1">April 2002</FONT></P><A NAME="745163"></A><P CLASS="PartNumber"><FONT FACE="Arial, Helvetica, sans-serif" SIZE="-1">Part No. A96545-01</FONT></P><A NAME="1000167"></A><P CLASS="BP">This document summarizes requirements, differences between SQL*Plus and its documented functionality, new features in this release and support information. It contains the following topics: </P><UL CLASS="LB1"> <LI CLASS="LB1" TYPE="DISC"><A NAME="1000231"></A> <A HREF="#1006740">Certification</a> <P> <LI CLASS="LB1" TYPE="DISC"><A NAME="1000152"></A> <A HREF="#997405">General Issues and Workarounds</a> <P> <LI CLASS="LB1" TYPE="DISC"><A NAME="1000154"></A> <A HREF="#1006817">New Features in SQL*Plus</a> <P> <LI CLASS="LB1" TYPE="DISC"><A NAME="1004286"></A> <A HREF="#1004218">New Features in Previous Releases</a> <P> <LI CLASS="LB1" TYPE="DISC"><A NAME="1000290"></A><A HREF="#1000456">Bugs Fixed</a> <P> <LI CLASS="LB1" TYPE="DISC"><A NAME="1000295"></A> <A HREF="#1005181">Support</a> <P> <LI CLASS="LB1" TYPE="DISC"><A NAME="1000300"></A> <A HREF="#997874">Desupport Notices</a> <P> <LI CLASS="LB1" TYPE="DISC"><A NAME="1000305"></A> <A HREF="#996768">Documentation Errata</a> <P></UL><A NAME="1006740"></A><!--TOC=h1-"1006740"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">1  Certification</FONT></H2><!--/TOC=h1--><A NAME="1006744"></A><P CLASS="BP">SQL*Plus (including <EM CLASS="Italic">i</EM>SQL*Plus) is certified against the operating systems set out in the operating-system specific Oracle documentation.</P><A NAME="1006748"></A><P CLASS="BP">SQL*Plus (including <EM CLASS="Italic">i</EM>SQL*Plus) is certified against Oracle9<EM CLASS="Italic">i</EM> Release 2 (9.2) and all supported versions of the Oracle Server.</P><A NAME="997405"></A><!--TOC=h1-"997405"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2  General Issues and Workarounds</FONT></H2><!--/TOC=h1--><A NAME="1006614"></A><P CLASS="BP">This section describes general issues and their workarounds for SQL*Plus.</P><A NAME="1007665"></A><!--TOC=h2-"1007665"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2.1  SQL*Plus Commands not in <EM CLASS="Italic">i</EM>SQL*Plus</FONT></H3><!--/TOC=h2--><A NAME="1008405"></A><P CLASS="BP">Appendix D of the <EM CLASS="Italic">SQL*Plus User's Guide and Reference</EM> lists SQL*Plus commands which have no context in <EM CLASS="Italic">i</EM>SQL*Plus, or have not been implemented for other reasons. Attempting to use an unsupported command raises an <EM CLASS="Italic">i</EM>SQL*Plus error message. </P><A NAME="1008944"></A><!--TOC=h2-"1008944"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2.2  Windows <EM CLASS="Italic">i</EM>SQL*Plus Server Port in Use</FONT></H3><!--/TOC=h2--><A NAME="1009670"></A><P CLASS="BP">After Oracle9<EM CLASS="Italic">i</EM> installation on Windows, if you are unable to connect to your <EM CLASS="Italic">i</EM>SQL*Plus Server, check that your Oracle HTTP Server is running, and that you are using the correct URL to connect to your <EM CLASS="Italic">i</EM>SQL*Plus Server. If you are still unable to connect, it may be because the port that the <EM CLASS="Italic">i</EM>SQL*Plus Server is attempting to use is already in use by another application. There is no consistent message to indicate that the port is already in use. A message, if any, depends on the application using the port. </P><A NAME="1009938"></A><P CLASS="BP">To determine the port number that the <EM CLASS="Italic">i</EM>SQL*Plus Server is attempting to use, do the following: </P><OL CLASS="LN1" TYPE="1"><LI CLASS="LN1" TYPE="1" VALUE="1"><A NAME="1009953"></A>Open the <EM CLASS="Italic">i</EM>SQL*Plus configuration file located at<P> <PRE CLASS="CE1"><A NAME="1009954"></A><CODE>%ORACLE_HOME%\sqlplus\admin</CODE>\isqlplus.conf</PRE> <LI CLASS="LN1" TYPE="1" VALUE="2"><A NAME="1009959"></A>Find the following block in the <EM CLASS="Italic">i</EM>SQL*Plus configuration file. <P> <PRE CLASS="CE1"><A NAME="1009960"></A>#<A NAME="1009961"></A># Setup the iSQL*Plus FastCGI application.<A NAME="1009962"></A>#<A NAME="1009963"></A><IfModule mod_fastcgi.c><A NAME="1009964"></A>FastCgiServer c:\oracle\bin\isqlplus -port 8228 -initial-env iSQLPlusNumberOfThreads=20 -initial-env iSQLPlusTimeOutInterval=30 -initial-env iSQLPlusLogLevel=warn -idle-timeout 3600<A NAME="1009965"></A></IfModule></PRE> <A NAME="1009966"></A><P CLASS="BP1">The number specified by the <CODE>-port</CODE> parameter, in this case shown as 8228, is the port number that the <EM CLASS="Italic">i</EM>SQL*Plus Server is attempting to use. </P></OL><A NAME="1009291"></A><P CLASS="BP">To view currently used ports and determine if the <EM CLASS="Italic">i</EM>SQL*Plus Server is trying to use a port that is already in use, run the following command in a Windows command prompt:</P> <PRE CLASS="CE"><A NAME="1009110"></A>netstat -an</PRE> <A NAME="1009369"></A><P CLASS="BP">If there is another application using the same port, you need to change the port used by the <EM CLASS="Italic">i</EM>SQL*Plus Server to a number that is not in use. By convention, it is recommended that you use a port number above 2000, and that you do not use 80 or 8080 as they are usually used by web services. A port number can be any unique integer number. </P><A NAME="1009373"></A><P CLASS="BP">To change the port number used by the <EM CLASS="Italic">i</EM>SQL*Plus Server, do the following<CODE>:</CODE></P><OL CLASS="LN1" TYPE="1"><LI CLASS="LN1" TYPE="1" VALUE="1"><A NAME="1009554"></A>Stop the Oracle HTTP Server.<P><LI CLASS="LN1" TYPE="1" VALUE="2"><A NAME="1009563"></A>Open the <EM CLASS="Italic">i</EM>SQL*Plus configuration file located at<P> <PRE CLASS="CE1"><A NAME="1009578"></A><CODE>%ORACLE_HOME%\sqlplus\admin</CODE>\isqlplus.conf</PRE> <LI CLASS="LN1" TYPE="1" VALUE="3"><A NAME="1009567"></A>Find the following block in the <EM CLASS="Italic">i</EM>SQL*Plus configuration file. Note that the line beginning FASTCGI is a continuous single line.<P> <PRE CLASS="CE1"><A NAME="1008954"></A>#<A NAME="1008955"></A># Setup the iSQL*Plus FastCGI application.<A NAME="1008956"></A>#<A NAME="1008957"></A><IfModule mod_fastcgi.c><A NAME="1008958"></A>FastCgiServer c:\oracle\bin\isqlplus -port 8228 -initial-env iSQLPlusNumberOfThreads=20 -initial-env iSQLPlusTimeOutInterval=30 -initial-env iSQLPlusLogLevel=warn -idle-timeout 3600<A NAME="1008959"></A></IfModule></PRE> <LI CLASS="LN1" TYPE="1" VALUE="4"><A NAME="1009544"></A>Replace the port number specified by the <CODE>-port</CODE> parameter, in this case shown as 8228, with a unique port number that you want the <EM CLASS="Italic">i</EM>SQL*Plus Server to use. <P><LI CLASS="LN1" TYPE="1" VALUE="5"><A NAME="1009635"></A>Save the <EM CLASS="Italic">i</EM>SQL*Plus configuration file.<P><LI CLASS="LN1" TYPE="1" VALUE="6"><A NAME="1009645"></A>Restart the Oracle HTTP Server.<P> </OL><A NAME="1008946"></A><!--TOC=h2-"1008946"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2.3  Connecting to Oracle7 from SQL*Plus 9.2</FONT></H3><!--/TOC=h2--><A NAME="1009921"></A><P CLASS="BP">Connections to an Oracle7 database from SQL*Plus 9.2 are not supported.</P><A NAME="1009916"></A><!--TOC=h2-"1009916"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2.4  Cannot WORD_WRAP NCLOB Columns </FONT></H3><!--/TOC=h2--><A NAME="998889"></A><P CLASS="BP">NCLOB columns cannot be formatted with WORD_WRAPPING. When the "COLUMN" command is used to format NCLOB columns with the "WORD_WRAP" option, the column data will WRAP instead of WORD_WRAP. </P><A NAME="998530"></A><!--TOC=h2-"998530"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2.5  Non-Blocking Database Calls</FONT></H3><!--/TOC=h2--><A NAME="998828"></A><P CLASS="BP">Non-blocking database calls to the Oracle9<EM CLASS="Italic">i</EM> Server are not supported on Windows. Therefore there is no cancel dialog while statements are executing in the SQL*Plus for Windows graphical user interface (GUI).</P><A NAME="998829"></A><!--TOC=h2-"998829"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2.6  Querying of LONG Columns </FONT></H3><!--/TOC=h2--><A NAME="1006732"></A><P CLASS="BP">Querying of LONG columns requires enough local memory to store the amount of data, as specified by the value of SET LONG command, irrespective of the value of the SET LONGCHUNKSIZE command. This restriction does not apply when querying LOBs.</P><A NAME="1006733"></A><!--TOC=h2-"1006733"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2.7  Privileged Connection Errors </FONT></H3><!--/TOC=h2--><A NAME="1005850"></A><P CLASS="BP">Some privileged connections to the Oracle9<EM CLASS="Italic">i</EM> Server may generate errors if SET APPINFO commands have been put in the global initialization file (<EM CLASS="Italic">glogin.sql</EM>) or a local initialization file (<EM CLASS="Italic">login.sql</EM>). </P><A NAME="1006781"></A><!--TOC=h2-"1006781"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">2.8  Loading a URL from <EM CLASS="Italic">i</EM>SQL*Plus Work screen </FONT></H3><!--/TOC=h2--><A NAME="1006815"></A><P CLASS="BP">Loading a script from a URL in the Work screen of <EM CLASS="Italic">i</EM>SQL*Plus may not work in some point releases of Netscape Navigator 4.x. You may get an error "SP2-0871: No script to load" due to a problem with Navigator. A work around is to load the file into another browser window and cut and paste the script into the Work screen. If you just want to execute the script without editing it, enter "@http://..." in the Input area of the Work screen.</P> <A NAME="1012924"></A> <!--TOC=h2-"1012924"--> <A NAME="1006817"></A> <!--TOC=h1-"1006817"--> <H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3  New Features in SQL*Plus</FONT></H2><!--/TOC=h1--><A NAME="1006818"></A><P CLASS="BP">SQL*Plus Release 9.2.0 is a superset of SQL*Plus 9.0.1. This section describes new features introduced in this release of SQL*Plus.</P><A NAME="999069"></A><!--TOC=h2-"999069"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.1  XMLType Support</FONT></H3><!--/TOC=h2--><A NAME="999070"></A><P CLASS="BP">There is additional support for XMLType in SQL*Plus. The DESCRIBE command now provides details about XMLType columns and usage in functions and procedures. The maximum size of a retrieved XMLType column is determined by SET LONG, and SET LONGCHUNKSIZE determines the size of the increments or chunks SQL*Plus uses to retrieve XMLType data.</P><A NAME="1008230"></A><!--TOC=h2-"1008230"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.2  SQLPLUS -L Argument</FONT></H3><!--/TOC=h2--><A NAME="1008213"></A><P CLASS="BP">There is a new command line argument for the SQLPLUS command, SQLPLUS -L which specifies not to reprompt for username or password if the initial connection does not succeed. This can be useful in operating-system scripts that must either succeed or fail. It is also useful for situations where you do not want to be reprompted for connection details if the Server is not running. This option is not available with the SQL*Plus for Windows graphical user interface.</P><A NAME="1003401"></A><!--TOC=h2-"1003401"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.3  _CONNECT_IDENTIFIER DEFINE Variable</FONT></H3><!--/TOC=h2--><A NAME="1008152"></A><P CLASS="BP">There is a new DEFINE variable, _CONNECT_IDENTIFIER. Where available, it contains the connection identifier as supplied by the user to make a connection. This allows the connection information to be accessed like any other DEFINE variable. </P><A NAME="999083"></A><!--TOC=h2-"999083"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.4  Cause/Action Text for SP2 Error Messages</FONT></H3><!--/TOC=h2--><A NAME="999084"></A><P CLASS="BP">There is new Cause and Action documentation for SP2- error messages. The UNIX <EM CLASS="Italic">oerr</EM> script now recognizes SP2- error prefixes to display the Cause and Action text.</P><A NAME="999085"></A>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -