30.Oracle数据库SQL开发之 SQLPlus使用——从SQL获取帮助信息

30.Oracle数据库SQL开发之 SQLPlus使用——从SQL获取帮助信息

欢迎转载，转载请标明出处：http://blog.csdn.net/notbaron/article/details/49722917

使用HELP信息可以从SQL*Plus中获取帮助

store@PDB1> help

 

 HELP

 ----

 

 Accesses this command line help system. EnterHELP INDEX or ? INDEX

 fora list of topics.

 

 You can view SQL*Plus resources at

    http://www.oracle.com/technology/documentation/

 

 HELP|? [topic]

store@PDB1> 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

然后查看具体某个帮助，例如

store@PDB1> HELP ACCEPT

 

 ACCEPT

 ------

 

 Reads a line of input and stores it in a givensubstitution variable.

 

 ACC[EPT] variable [NUM[BER] | CHAR | DATE |BINARY_FLOAT | BINARY_DOUBLE]

 [FOR[MAT] format] [DEF[AULT] default] [PROMPTtext | NOPR[OMPT]] [HIDE]