阅读:2361回复:2
如何给sqlplus 安装help
<b><FONT face="Comic Sans MS">
</FONT></b>Installing the Help Facility Manually The Help Facility may be installed manually using the shell script $ORACLE_HOME/bin/helpins. Before you run the script, the SYSTEM_PASS environment variable should be set to the SYSTEM schema name and password. For example: $ setenv SYSTEM_PASS SYSTEM/MANAGER $ helpins If the SYSTEM_PASS variable is not set, helpins prompts you for the SYSTEM password and loads the help data into the SYSTEM schema. You can also run $ORACLE_HOME/sqlplus/help/helpbld.sql helpus.sql to install the Help Facility. The system user can run the file helpbld.sql and its argument, helpus.sql, in SQL*Plus to create Help Facility Tables. For example: $ sqlplus system/manager SQL> @?/sqlplus/admin/help/helpbld.sql helpus.sql |
|
|
1楼#
发布于:2007-04-19 14:37
好东东
|
|
2楼#
发布于:2005-04-20 00:07
使用时键入help index显示帮助项,然后寻找相应的帮助
SQL> help index @ COPY PAUSE SHUTDOWN @@ DEFINE PRINT SPOOL / DEL PROMPT SQLPLUS ACCEPT DESCRIBE QUIT START APPEND DISCONNECT RECOVER STARTUP ARCHIVE LOG EDIT REMARK STORE ATTRIBUTE EXECUTE REPFOOTER TIMING BREAK EXIT REPHEADER TTITLE BTITLE GET RESERVED WORDS (SQL) UNDEFINE CHANGE HELP RESERVED WORDS (PL/SQL) VARIABLE CLEAR HOST RUN WHENEVER OSERROR COLUMN INPUT SAVE WHENEVER SQLERROR COMPUTE LIST SET CONNECT PASSWORD SHOW SQL> help copy COPY ---- COPY copies data from a query to a table in a local or remote database. COPY {FROM database | TO database | FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, ...)] USING query where database has the following syntax: username[/password]@connect_identifier |
|
|