readme_sqlplus.htm

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

<!--TOC=h2-"999085"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.5&#32; @URL Support</FONT></H3>
<!--/TOC=h2-->
<A NAME="999086"></A>
<P CLASS="BP">
The @URL syntax is now supported on all platforms. Use '@URL' to run a script on any platform, not just Windows.
</P>

<A NAME="999096"></A>
<!--TOC=h2-"999096"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6&#32; <EM CLASS="Italic">i</EM>SQL*Plus </FONT></H3>
<!--/TOC=h2-->
<A NAME="999104"></A>
<P CLASS="BP">
There are changes to the functionality of the <EM CLASS="Italic">i</EM>SQL*Plus user interface, and to its look and feel.
</P>

<A NAME="997594"></A>
<!--TOC=h3-"997594"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6.1&#32; UNIX Support</FONT></H4>
<!--/TOC=h3-->
<A NAME="999110"></A>
<P CLASS="BP">
The <EM CLASS="Italic">i</EM>SQL*Plus Server is supported on UNIX platforms.
</P>

<A NAME="999340"></A>
<!--TOC=h3-"999340"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6.2&#32; Set System Variables</FONT></H4>
<!--/TOC=h3-->
<A NAME="1004022"></A>
<P CLASS="BP">
There is a new <EM CLASS="Italic">i</EM>SQL*Plus System Variables screen. This screen provides a graphical interface to the system variables applicable to <EM CLASS="Italic">i</EM>SQL*Plus. It allows you to view current settings, and to change one or more settings from a single screen. The default system variable settings are used each time you start a new <EM CLASS="Italic">i</EM>SQL*Plus session. You can also use the SET command in the Work screen if you prefer.
</P>

<A NAME="997599"></A>
<!--TOC=h3-"997599"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6.3&#32; History Screen</FONT></H4>
<!--/TOC=h3-->
<A NAME="1003944"></A>
<P CLASS="BP">
There is a new <EM CLASS="Italic">i</EM>SQL*Plus History screen. This screen allows you to reload one or more scripts that you have previously executed in the same session. 
</P>
<A NAME="1006116"></A>
<P CLASS="BP">
A History entry is created each time you execute a script. The number of entries listed is definable through the Preferences screen. Each <EM CLASS="Italic">i</EM>SQL*Plus session has its own history list which is cleared when that session ends.
</P>

<A NAME="997600"></A>
<!--TOC=h3-"997600"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6.4&#32; New Session</FONT></H4>
<!--/TOC=h3-->
<A NAME="1008147"></A>
<P CLASS="BP">
There is a new icon called New Session in the <EM CLASS="Italic">i</EM>SQL*Plus user interface. The New Session icon starts a new <EM CLASS="Italic">i</EM>SQL*Plus session in a separate web browser window. You can log in as the same user or as any other valid user. 
</P>

<A NAME="1004059"></A>
<!--TOC=h3-"1004059"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6.5&#32; Cancel Script</FONT></H4>
<!--/TOC=h3-->
<A NAME="1004061"></A>
<P CLASS="BP">
There is a new Cancel button on the <EM CLASS="Italic">i</EM>SQL*Plus Work screen. The Cancel button interrupts the script currently running in your <EM CLASS="Italic">i</EM>SQL*Plus session. 
</P>

<A NAME="1004062"></A>
<!--TOC=h3-"1004062"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6.6&#32; <EM CLASS="Italic">i</EM>SQL*Plus DBA Login</FONT></H4>
<!--/TOC=h3-->
<A NAME="1004163"></A>
<P CLASS="BP">
The <EM CLASS="Italic">i</EM>SQL*Plus DBA Login screen contains a Privilege dropdown list to select either SYSDBA or SYSOPER privileged login to perform system administration tasks. This field is not available through the standard <EM CLASS="Italic">i</EM>SQL*Plus Login screen. Use the <EM CLASS="Italic">i</EM>SQL*Plus DBA URL to access the DBA Login screen. 
</P>
<A NAME="1006828"></A>
<P CLASS="BP">
Once logged in with DBA privileges, the <EM CLASS="Italic">i</EM>SQL*Plus screens have the <EM CLASS="Italic">i</EM>SQL*Plus DBA logo to clearly distinguish this administrative session from standard <EM CLASS="Italic">i</EM>SQL*Plus sessions. 
</P>

<A NAME="1010665"></A>
<!--TOC=h3-"1010665"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6.7&#32; <EM CLASS="Italic">i</EM>SQL*Plus Server Configuration Parameters</FONT></H4>
<!--/TOC=h3-->
<A NAME="1012344"></A>
<P CLASS="BP">
In addition to the existing <CODE>iSQLPlusTimeOutInterval</CODE> parameter, there are six new <EM CLASS="Italic">i</EM>SQL*Plus Server parameters. You can change the values of the <EM CLASS="Italic">i</EM>SQL*Plus Server parameters in the <EM CLASS="Italic">isqlplus.conf</EM> configuration file which is located in the <CODE>$ORACLE_HOME/sqlplus/admin/</CODE> directory.
</P>

<A NAME="1012648"></A>
<H5 CLASS="SH3"><FONT FACE="Arial, Helvetica, sans-serif">iSQLPlusLogLevel</FONT></H5>
<A NAME="1012652"></A>
<P CLASS="BP">
Enables <EM CLASS="Italic">i</EM>SQL*Plus to maintain log files and determines to what level log files are maintained. The default log file location is <CODE>$ORACLE_HOME/sqlplus/log/isqlplus/log.xml</CODE>. 
</P>
<A NAME="1012656"></A>
<P CLASS="BP">
<EM CLASS="Italic">i</EM>SQL*Plus must be able to write to the <CODE>$ORACLE_HOME/sqlplus/log</CODE> directory. This directory has owner write permissions. If <EM CLASS="Italic">i</EM>SQL*Plus is running as the <CODE>nobody</CODE> user and therefore cannot write to the log file, you must manually give <EM CLASS="Italic">i</EM>SQL*Plus write permissions on the log file. It is not recommended to grant world write permission to the file except for temporary testing or tracing purposes.
</P>

<A NAME="1012347"></A>
<H5 CLASS="SH3"><FONT FACE="Arial, Helvetica, sans-serif">iSQLPlusNumberOfThreads </FONT></H5>
<A NAME="1012423"></A>
<P CLASS="BP">
Sets the maximum number of simultaneous HTTP requests that can be handled by the <EM CLASS="Italic">i</EM>SQL*Plus Server.
</P>

<A NAME="1012364"></A>
<H5 CLASS="SH3"><FONT FACE="Arial, Helvetica, sans-serif">iSQLPlusHashTableSize</FONT></H5>
<A NAME="1012504"></A>
<P CLASS="BP">
Sets the maximum number of concurrent <EM CLASS="Italic">i</EM>SQL*Plus sessions that can be handled by the <EM CLASS="Italic">i</EM>SQL*Plus Server. The default value is derived from the value of the <CODE>iSQLPlusNumberOfThreads</CODE> parameter.
</P>

<A NAME="1012508"></A>
<H5 CLASS="SH3"><FONT FACE="Arial, Helvetica, sans-serif">iSQLPlusConnectIdList</FONT></H5>
<A NAME="1012511"></A>
<P CLASS="BP">
Replaces the Connection Identifier text field on the Login screen with a drop-down list of databases that users can access in <EM CLASS="Italic">i</EM>SQL*Plus. This allows greater security for <EM CLASS="Italic">i</EM>SQL*Plus Servers in hosted environments.
</P>

<A NAME="1012396"></A>
<H5 CLASS="SH3"><FONT FACE="Arial, Helvetica, sans-serif">iSQLPlusAllowUserEntMap</FONT></H5>
<A NAME="1012398"></A>
<P CLASS="BP">
Controls whether <EM CLASS="Italic">i</EM>SQL*Plus permits users to change the SET MARKUP HTML ENTMAP and COLUMN ENTMAP settings. 
</P>
<A NAME="1012387"></A>
<P CLASS="BP">
In HTML, entity mapping replaces characters of special significance with printable representations of those characters. By default, entity mapping is enabled, and <CODE>iSQLPlusAllowUserEntMap</CODE> is set to none, preventing users from changing the entity mapping settings, and preventing the use of user defined HTML in <EM CLASS="Italic">i</EM>SQL*Plus output. 
</P>

<A NAME="1012638"></A>
<H5 CLASS="SH3"><FONT FACE="Arial, Helvetica, sans-serif">-idle-timeout</FONT></H5>
<A NAME="1012639"></A>
<P CLASS="BP">
Sets the time the Oracle HTTP Server waits for results from <EM CLASS="Italic">i</EM>SQL*Plus.
</P>

<A NAME="1012338"></A>
<!--TOC=h3-"1012338"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.6.8&#32; <EM CLASS="Italic">i</EM>SQL*Plus Online Help Language Support</FONT></H4>
<!--/TOC=h3-->
<A NAME="1010666"></A>
<P CLASS="BP">
The <EM CLASS="Italic">i</EM>SQL*Plus online help is available in the following languages:
</P>

<UL>

<A NAME="1010930"></A>
<P CLASS="BP1">
Brazilian Portuguese <br>French <br>German <br>Italian <br>Japanese <br>Korean <br>Simplified Chinese <br>Spanish 
</P>
</UL>

<A NAME="997604"></A>
<!--TOC=h2-"997604"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.7&#32; <EM CLASS="Italic">i</EM>SQL*Plus Extension for Windows</FONT></H3>
<!--/TOC=h2-->
<A NAME="1008161"></A>
<P CLASS="BP">
The <EM CLASS="Italic">i</EM>SQL*Plus Extension for Windows provides a context menu to load or execute local SQL scripts in <EM CLASS="Italic">i</EM>SQL*Plus. The <EM CLASS="Italic">i</EM>SQL*Plus Extension for Windows works with .SQL files and is activated by right clicking a .SQL file in Windows Explorer. 
</P>
<A NAME="1008168"></A>
<P CLASS="BP">
After you have configured an <EM CLASS="Italic">i</EM>SQL*Plus Server, you can use the context menu to: 
</P>

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1004207"></A>Run or load local scripts accessible from your workstation
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1004215"></A>Select the server to use from a list of configured <EM CLASS="Italic">i</EM>SQL*Plus Servers
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1004217"></A>Choose the double click file association for .SQL files
<P>

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

<A NAME="1006838"></A>
<!--TOC=h3-"1006838"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">3.7.1&#32; Language Support in <EM CLASS="Italic">i</EM>SQL*Plus Extension for Windows</FONT></H4>
<!--/TOC=h3-->
<A NAME="1006842"></A>
<P CLASS="BP">
On Windows XP, Windows 2000 and Windows NT, the <EM CLASS="Italic">i</EM>SQL*Plus Extension for Windows supports the following languages:
</P>

<UL>

<A NAME="1006843"></A>
<P CLASS="BP1">
Brazilian Portuguese<br>English <br>French/Canadian French<br>German<br>Italian<br>Japanese<br>Korean<br>Simplified Chinese<br>Spanish/LA Spanish<br>Traditional Chinese
</P>
</UL>
<A NAME="1006700"></A>
<P CLASS="BP">
On Windows 98, the <EM CLASS="Italic">i</EM>SQL*Plus Extension for Windows is only available in English. 
</P>

<A NAME="1004218"></A>
<!--TOC=h1-"1004218"-->
<H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">4&#32; New Features in Previous Releases</FONT></H2>


<!--/TOC=h1-->
<A NAME="1004295"></A>
<P CLASS="BP">
This section lists new features introduced to SQL*Plus in previous releases.
</P>

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

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001215"></A><EM CLASS="Italic">i</EM>SQL*Plus
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001216"></A>SET APPINFO
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001217"></A>Command line switches
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1002259"></A>SET SQLPLUSCOMPATIBILITY
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1002270"></A>Read script from Uniform Resource Identifier
<P>
</UL>

<A NAME="1001289"></A>
<!--TOC=h2-"1001289"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">4.2&#32; New Features in SQL*Plus 8.1.7 Production</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001295"></A>SQLPLUS -MARKUP and SET MARKUP
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001296"></A>COLUMN ENTMAP {ON|OFF}
<P>
</UL>

<A NAME="1001386"></A>
<!--TOC=h2-"1001386"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">4.3&#32; New Features in SQL*Plus 8.1.6 Production</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001392"></A>SQLPLUS -MARKUP
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001393"></A>SET MARKUP
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001394"></A>SHOW MARKUP
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001395"></A>SQLPLUS -RESTRICT
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001396"></A>Help System
<P>
</UL>

<A NAME="1001487"></A>
<!--TOC=h2-"1001487"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">4.4&#32; New Features in SQL*Plus 8.1.5 Production</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001493"></A>SET SQLBLANKLINES
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001494"></A>SHOW SQLBLANKLINES
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001495"></A>SQL*Plus Messages
<P>
</UL>

<A NAME="1001576"></A>
<!--TOC=h2-"1001576"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">4.5&#32; New Features in SQL*Plus 8.1.4 Beta</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1004269"></A>SP2- prefix for SQL*Plus Messages
<P>
</UL>

<A NAME="1003915"></A>
<!--TOC=h2-"1003915"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">4.6&#32; New Features in SQL*Plus 8.1.3 Beta</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001581"></A>ARCHIVE LOG
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001582"></A>DESCRIBE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001583"></A>RECOVER
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001585"></A>SET AUTORECOVERY
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001586"></A>SET DESCRIBE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001587"></A>SET INSTANCE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001588"></A>SET LOGSOURCE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001589"></A>SHOW AUTORECOVERY
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001591"></A>SHOW DESCRIBE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001592"></A>SHOW INSTANCE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001593"></A>SHOW LOGSOURCE
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001594"></A>SHOW PARAMETERS
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001595"></A>SHOW SGA
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001596"></A>SHUTDOWN
<P>

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001597"></A>STARTUP
<P>
</UL>

<A NAME="1001794"></A>
<!--TOC=h2-"1001794"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">4.7&#32; New Features in SQL*Plus 8.0.5 Production</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001800"></A>CONNECT supports mode of connection
<P>
</UL>

<A NAME="1001812"></A>
<!--TOC=h2-"1001812"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">4.8&#32; New Features in SQL*Plus 8.0.3 Production</FONT></H3>
<!--/TOC=h2-->

<UL CLASS="LB1">

<LI CLASS="LB1" TYPE="DISC"><A NAME="1001816"></A>CREATE TYPE
<P>