首页 > 代码库 > slqplus 帮助手册

slqplus 帮助手册

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

D:\app\product\11.1.0\db_1\sqlplus\admin\help>sqlplus /nologSQL*Plus: Release 11.1.0.7.0 - Production on Tue Oct 28 10:55:50 2014Copyright (c) 1982, 2008, Oracle.  All rights reserved.SQL> helpSP2-0171: HELP system not available.SQL> connect / as sysdbaConnected.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:\app\product\11.1.0\db_1\sqlplus\admin\help>dir 驱动器 D 中的卷没有标签。 卷的序列号是 C2A5-4DE0 D:\app\product\11.1.0\db_1\sqlplus\admin\help 的目录2014/04/15  16:48    <DIR>          .2014/04/15  16:48    <DIR>          ..2003/03/09  23:02               278 helpbld.sql2000/06/28  03:30               356 helpdrop.sql2007/06/25  21:52            65,864 helpus.sql2003/03/20  04:30             1,565 hlpbld.sql               4 个文件         68,063 字节               2 个目录 244,954,464,256 可用字节

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

SQL> conn hr/hrConnected.SQL> help indexEnter 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     SHOWSQL>

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

 

slqplus 帮助手册