slqplus 帮助手册

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

D:\app\product\11.1.0\db_1\sqlplus\admin\help>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:\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.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

上一篇:php扩展redis,编译安装redis服务


下一篇:xmpp整理笔记:用户网络连接及好友的管理