slqplus 帮助手册

1.查看sqlplus的帮助是否可用，必须登录了才可用。

D:appproduct11.1.0db_1sqlplusadminhelp>sqlplus /nolog

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Oct 28 10:55:50 2014

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

SQL> help
SP2-0171: HELP system not available.
SQL> connect / as sysdba
Connected.
SQL> help

 HELP
 ----

 Accesses this command line help system. Enter HELP INDEX or ? INDEX
 for a list of topics.

 You can view SQL*Plus resources at
     http://www.oracle.com/technology/tech/sql_plus/
 and the Oracle Database Library at
     http://www.oracle.com/technology/documentation/

 HELP|? [topic]

2.如果不能用在以下目录查找安装

D:appproduct11.1.0db_1sqlplusadminhelp>dir
 驱动器 D 中的卷没有标签。
 卷的序列号是 C2A5-4DE0

 D:appproduct11.1.0db_1sqlplusadminhelp 的目录

2014/04/15  16:48    <DIR>          .
2014/04/15  16:48    <DIR>          ..
2003/03/09  23:02               278 helpbld.sql
2000/06/28  03:30               356 helpdrop.sql
2007/06/25  21:52            65,864 helpus.sql
2003/03/20  04:30             1,565 hlpbld.sql
               4 个文件         68,063 字节
               2 个目录 244,954,464,256 可用字节

3.切换其他用户观察是否可用

SQL> conn hr/hr
Connected.
SQL> help index

Enter Help [topic] for help.

 @             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                      XQUERY
 CONNECT       PASSWORD     SHOW


SQL>

4.查看具体的命令帮助

SQL> help @

 @ ("at" sign)
 -------------
 Runs the SQL*Plus statements in the specified script. The script can be
 called from the local file system or a web server.

 @ {url|file_name[.ext]} [arg ...]

 where url supports HTTP and FTP protocols in the form:

    http://host.domain/script.sql


 @@ (double "at" sign)
 ---------------------

 Runs the specified script. This command is almost identical to
 the @ command. It is useful for running nested scripts because it
 has the additional functionality of looking for the nested script
 in the same url or path as the calling script.

 @@ {url|file_name[.ext]} [arg ...]


SQL>

引用：

http://blog.csdn.net/leshami/article/details/8852568