sqlplus HELP

最新推荐文章于 2023-03-08 10:40:50 发布

「已注销」

最新推荐文章于 2023-03-08 10:40:50 发布

阅读量276

点赞数

分类专栏： Oracle Sqlplus 文章标签：数据库

Oracle Sqlplus 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

使用sqlplus命令登录系统后,查看help

$ sqlplus system

SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 1 09:33:36 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> help
SP2-0171: HELP system not available.

这里我们可以看到提示HELP system not available.

需要导入help表才可以使用sqlplus中的help命令

sqlplus的脚本存放路径$ORACLE_HOME/sqlplus/admin/help/

导入help(必须system用户)

SQL> show user;
USER is "SYSTEM"
SQL> @?/sqlplus/admin/help/hlpbld.sql helpus.sql

此时查看help命令

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]

删除help的脚本@?sqlplus/admin/help/helpdrop.sql