首页 > 代码库 > 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 帮助手册
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。