readme_sqlplus.htm

来自「Debian中文参考手册,系统介绍了Debian系统」· HTM 代码 · 共 1,507 行 · 第 1/4 页

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001817"></A>DESCRIBE TABLE, VIEW, PROCEDURE, FUNCTION, SYNONYM, PACKAGE, OBJECT TYPE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001818"></A>PASSWORD
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001819"></A>CONNECT
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001820"></A>SET MAXDATA and CLOSECURSOR commands have been obsoleted
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1003104"></A>SET COMPATIBILITY command modified
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1003105"></A>SET CONSTRAINT command is supported
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001825"></A>SET NEWPAGE command has the new keyword NONE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1003176"></A>SET LOBOFFSET
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1003177"></A>VARIABLE supports NCHAR, NVARCHAR2, NCLOB, CLOB
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1003178"></A>SHOW ERRORS
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001829"></A>ATTRIBUTE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001830"></A>EXIT
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001831"></A>Version variable _SQLPLUS_RELEASE
<P>
</UL>

<A NAME="1000456"></A>
<!--TOC=h1-"1000456"-->
<H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">5&#32; Bugs Fixed</FONT></H2>


<!--/TOC=h1-->
<A NAME="997843"></A>
<P CLASS="BP">
The following section lists bugs fixed in SQL*Plus. Numbers in parentheses following the problem description refer to bug numbers in the Oracle Bug Database.
</P>

<A NAME="1007355"></A>
<!--TOC=h2-"1007355"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">5.1&#32; Bugs Fixed in SQL*Plus 9.2 Production</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007257"></A>Describe command now produces the correct result for a VARRAY of NCHAR (2216859)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007461"></A>SQL*Plus no longer terminates abnormally when entering SHOW ERRORS for an errored PL/SQL block which contains comments between the package type and package name (2026644)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007462"></A>Correct number of characters retrieved for a SELECT of NCLOB datatype with NLS_NCHAR environment parameter set (1987259)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007267"></A>SQL*Plus displays an error if a substitution variable exceeds 240 bytes (1934520)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007270"></A>When attempting to connect to an invalid connection identifier as a privileged user, either an invalid error is reported, or the user is granted an idle instance connection to a local database (1778036)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007274"></A>DESCRIBEing an object type after a SELECT no longer causes garbage in the object name (2151078)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007277"></A>Setting NLS_DATE_FORMAT from ALTER SESSION within a function changes the date format (1914259)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007280"></A>Running a SQL script with a path longer than 80 characters no longer results in abnormal termination on Windows NT (1925208)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007283"></A>SQL*Plus Windows graphical user interface no longer terminates abnormally with SET PAUSE ON (1902459)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007285"></A>SET CONSTRAINTS now works in NLS MODE (1883466)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007287"></A>Now able to change the password for a username that contains white space, such as "ab ab" (1852419)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007290"></A>No longer able to login with invalid Oracle account for OS authenticated user (1815491)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007293"></A>Now displays correct output in multibyte for WORD_WRAPPED and SERVEROUTPUT when MARKUP HTML ON (1805106)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007296"></A>SELECT on a TIMESTAMP datatype on HP (64 bit) platform no longer results in "ORA-01877: string is too long for internal buffer" (1782816)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007299"></A>A failed connection request to a remote database no longer results in connection to a local database without the user being aware this has occurred. An error is now displayed (1777627)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007302"></A>Control-C interrupts in a SQL*Plus session now reaches shadow process (1751168)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007305"></A>SQL*Plus no longer terminates abnormally when using the BREAK command (1723633)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007307"></A>EOF encountered during substitution with input redirection no longer results in error (1686205)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007310"></A>SQL*Plus no longer terminates abnormally when using DESCRIBE command to describe a nested table of type 'anydata' (1656591)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007313"></A>SQL*Plus no longer terminates abnormally when using the DESCRIBE command to describe a public synonym for a non-existent table (1727607)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007588"></A>SQL*Plus no longer terminates abnormally when trying to insert data that is 4000 characters long (1397704)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007589"></A>The column width of the column defined "fold_after" is now correctly set (716638)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007322"></A>HTML output from COLUMN: is no longer missing after word_wrap (1872657)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007324"></A>The error indicator shows the position of the error in HTML output (including <EM CLASS="Italic">i</EM>SQL*Plus) (1477471)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007327"></A>DESCRIBE of FLOAT(x) now shows FLOAT(x) instead of NUMBER(x) DESCRIBE of REAL now shows FLOAT(63) (2042623)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007330"></A>SQL*Plus no longer terminates abnormally when trying to copy an object datatype which is not supported in the COPY command (2221928)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1007333"></A>Internal code changes (2127638, 2088130, 2088085, 1930054, 1903571, 1808191, 1776566, 1764208, 1764205, 1762466, 1635304, 1584406, 1479508, 1855842)
<P>
</UL>

<A NAME="1007379"></A>
<!--TOC=h2-"1007379"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">5.2&#32; Bugs Fixed in SQL*Plus 9.0.1 Production</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="997845"></A>Recovery dialog no longer prompts for a log when end of disabled thread reached (1111709)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000321"></A>Recovery dialog no longer terminates when bad log name is entered (1169101)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000333"></A>Describe command can now describes synonyms based on schema object created with double quotes (1598520, 1217127, 1035350)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000334"></A>SQL*Plus now displays ORA-28002 when password expiry is in grace period (1326865)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000335"></A>SHOW ERRORS shows the errors for ALTER TYPE COMPILE BODY (1341524)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000336"></A>SQL*Plus now gives an error instead of prompting for a password when a user is not in the DBA group (1657213)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000337"></A>SQL*Plus now accepts scripts from the Operating System with a space between the '@' sign and the script name (1714104, 1617267)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000341"></A>SQL*Plus now handles input files that have a control/d (EOF) character (1265859)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000346"></A>"SP2-0614: Server version too low for this feature" will no longer appear when "glogin.sql" contains 'set serveroutput on' (1552238)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000351"></A>SQL*Plus now allows for blank spaces before the '/' to terminate and execute a PL/SQL block (1312929)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1005191"></A>An abnormal termination when re-executing a select with a break statement has been fixed (996778)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000363"></A>The TABLE clause was added to SET MARKUP usage message (1288901)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000368"></A>AUTOTRACE no longer gives an error for small values of ARRAYSIZE (1364197)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000373"></A>Some problems with SHOW ERRORS for Java source with multibyte characters have been fixed (1458572)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000378"></A>The usage statement is no longer displayed when issuing a valid 'SHOW ERRORS' command for a Java source/class (1485281)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000383"></A>HTML tags for output after a SKIP are now valid (1477515)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000388"></A>A problem with HTML tag markup and BTITLE has been fixed (1477529)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000393"></A>Numeric variables in titles are no longer displayed correctly if a NULL value is the first data item selected (1265664)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000398"></A>DESCRIBE object does not give consistent information for object type method has been fixed (997861)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000403"></A>SQL*Plus bind variable assignment results in a 'PLS-00553' error if issued within the same SQL*Plus session used to shutdown and restart the database (1335603)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000408"></A>Compilation of a Java source results in SQL*Plus hanging when the character set is a multi-byte character set (1381064)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000413"></A>Now when MARKUP HTML OFF is issued, no HTML output is produced. It does not matter if MARKUP HTML SPOOL is ON or OFF (1420656)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000418"></A>An invalid password change issued from the SQL*Plus PASSWORD command should not disconnect the user (1620381)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1000423"></A>SET AUTOTRACE ON does not work with certain character set on the client side. It results in ORA-00923 (1200008)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1005178"></A>SQL*Plus should allow CONNECT AS SYSDBA when instance is hung (1508783)
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1005203"></A>Internal code changes (1290197, 1301950, 1353644, 1286724, 1674627, 1705536, 1713564, 1265887, 1687097, 1698337, 1698361, 1698379, 1698422, 1702306, 1705970, 1706081, 1707889, 1715102, 1715112, 1715121, 1716888)
<P>
</UL>

<A NAME="1005181"></A>
<!--TOC=h1-"1005181"-->
<H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">6&#32; Support</FONT></H2>


<!--/TOC=h1-->
<A NAME="997872"></A>
<P CLASS="BP">
For SQL*Plus and <EM CLASS="Italic">i</EM>SQL*Plus support, please contact your local Oracle Support Services Center. There is also an <EM CLASS="Italic">i</EM>SQL*Plus Discussion Forum on the Oracle Technology Network located at <A HREF="http://otn.oracle.com/">	http://otn.oracle.com/</a> which may be helpful. 
</P>

<A NAME="997874"></A>
<!--TOC=h1-"997874"-->
<H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">7&#32; Desupport Notices</FONT></H2>


<!--/TOC=h1-->
<A NAME="997875"></A>
<P CLASS="BP">
This section gives advance notice of the desupport of SQL*Plus commands and interfaces. It is not official notice of desupport dates, nor is it intended to replace the Oracle obsolescence process. This information provides you with advance warning that Oracle Corporation intends to desupport these features/interfaces in upcoming releases. 
</P>

<A NAME="997876"></A>
<!--TOC=h2-"997876"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">7.1&#32; COPY Command</FONT></H3>
<!--/TOC=h2-->
<A NAME="998118"></A>
<P CLASS="BP">
COPY supports the datatypes listed for the COPY command in the <EM CLASS="Italic">SQL*Plus User's Guide and Reference</EM>, but no new datatypes will be supported. The COPY command may be obsoleted in a future release of SQL*Plus. 
</P>

<A NAME="998119"></A>
<!--TOC=h2-"998119"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">7.2&#32; Windows Graphical User Interface</FONT></H3>
<!--/TOC=h2-->
<A NAME="998120"></A>
<P CLASS="BP">
The SQL*Plus for Windows graphical user interface (GUI) will be desupported in future releases of SQL*Plus. The browser-based <EM CLASS="Italic">i</EM>SQL*Plus user interface will replace the SQL*Plus for Windows GUI. The SQL*Plus for Windows command line (DOS) interface will continue to be supported.
</P>

<A NAME="996768"></A>
<!--TOC=h1-"996768"-->
<H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">8&#32; Documentation Errata</FONT></H2>


<!--/TOC=h1-->
<A NAME="1006857"></A>
<P CLASS="BP">
The section describes known errors in the documentation.
</P>

<A NAME="1011634"></A>
<!--TOC=h2-"1011634"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">8.1&#32; <EM CLASS="Italic">i</EM>SQL*Plus Online Help</FONT></H3>
<!--/TOC=h2-->
<A NAME="1011974"></A>
<P CLASS="BP">
The following are known changes to the <EM CLASS="Italic">i</EM>SQL*Plus online help by section.
</P>

<A NAME="1012683"></A>
<!--TOC=h3-"1012683"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">8.1.1&#32; User Interface</FONT></H4>
<!--/TOC=h3-->
<A NAME="1012684"></A>
<P CLASS="BP">
In <STRONG CLASS="Bold"><EM CLASS="Italic">i</EM>SQL*Plus Extension for Microsoft Windows</STRONG>, under the heading "Context Menu" there should be an additional bullet point:
</P>

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1006858"></A>choose the language to use from a list of configured languages
<P>
</UL>

<A NAME="1011439"></A>
<!--TOC=h3-"1011439"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">8.1.2&#32; Configuring <EM CLASS="Italic">i</EM>SQL*Plus</FONT></H4>
<!--/TOC=h3-->
<A NAME="1011644"></A>
<P CLASS="BP">
In <STRONG CLASS="Bold">Configuring the Client Tier</STRONG> <CODE>&gt;</CODE> <STRONG CLASS="Bold">Retained Session Settings</STRONG>, the first three bullet points should not appear:
</P>
<UL>

<UL CLASS="LB2">

<LI CLASS="LB2" TYPE="DISC"><A NAME="1005437"></A>Username
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1005438"></A>Connection identifier
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1004551"></A>Privilege
<P>
</UL>
</UL>
<A NAME="1004375"></A>
<P CLASS="BP">
In this same section, the final para should read:
</P>

<UL>

<A NAME="1011075"></A>
<P CLASS="BP1">
Your username, password and your output preferences are not saved.
</P>
</UL>
<A NAME="1011327"></A>
<P CLASS="BP">

</P>
<A NAME="1011438"></A>
<P CLASS="BP">
In <STRONG CLASS="Bold">Configuring the <EM CLASS="Italic">i</EM>SQL*Plus Server</STRONG>, the following bullet points should be added:
</P>
<UL>

<UL CLASS="LB2">

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011363"></A>Set the iSQLPlusHashTableSize parameter
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011364"></A>Set the iSQLPlusConnectIdList parameter
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011365"></A>Set the -idle-timeout parameter
<P>

<LI CLASS="LB2" TYPE="DISC"><A NAME="1011440"></A>Set the iSQLPlusAllowUserEntMap parameter
<P>
</UL>
</UL>
<A NAME="1011297"></A>
<P CLASS="BP">
The following subsections associated with the bullet points should also be added: 
</P>

<UL>

<A NAME="1011447"></A>
<P CLASS="BP1">
<STRONG CLASS="Bold">Setting the <EM CLASS="Italic">i</EM>SQL*Plus Hash Table Size Parameter</STRONG>
</P>

<A NAME="1011387"></A>
<P CLASS="BP1">
The number of hash table entries is defined by the <CODE>iSQLPlusHashTableSize</CODE> initialization parameter. Each user session consumes one entry in the hash table even if it is idle. Its default value is derived from the value of the <CODE>iSQLPlusNumberOfThreads</CODE> parameter value. However, <CODE>iSQLPlusHashTableSize</CODE> can be set independently to tune the system. 
</P>