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]