问题提出:
我们在使用sqlplus使,经常记不清楚某个具体的sqlplus命令或某个sql语句的语法,oracle有没有像其他软件一样的联机帮助文档呢?
有,下面我们就来看看如何进行安装。
解决办法:
1、安装sqlplus的帮助信息
方法一:(推荐使用这种方式安装)
# $ORACLE_HOME/bin//helpins system
默认为us
helpins是一个批处理文件,大家可以打开看到里面的内容。
方法二:
# cd $ORACLE_HOME/sqlplus/admin/help
# ls -l
helpbld.sql //安装help的脚本,需要两个参数。
helpdrop.sql //删除help的脚本。
helpus.sql //英文帮助。
hlpbld.sql //安装help的脚本,需要一个参数。
具体方法如下:
#sqlplus system/
sql>@?/sqlplus/admin/help/helpbld.sql ?/sqlplus/admin/help helpus.sql
或者
sql>@?/sqlplus/admin/help/hlpbld.sql ?/sqlplus/admin/help/helpus.sql
2、检查sqlplus帮助是否可用
SQL> help index //或者help topics
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
CONNECT PASSWORD SHOW
//以上只有sqlplus的帮助,如果想查看某个sql语法,不支持,还需要下面的步骤
3、安装sql语法的帮助
下载附件help.sql,并将此文件拷贝到$ORACLE_HOME/sqlplus/admin/help目录下,然后使用上面相同的方法安装。
#sqlplus system/
sql>@?/sqlplus/admin/help/hlpbld.sql ?/sqlplus/admin/help/help.sql
4、查看sql帮助是否可用
SQL> help topic
Help is available on the following topics:
%ROWTYPE ATTRIBUTE
%TYPE ATTRIBUTE
/
@
@@
ACCEPT
ALLOCATE (EMBEDDED SQL)
ALTER CLUSTER
ALTER DATABASE
ALTER FUNCTION
ALTER INDEX
ALTER PACKAGE
ALTER PROCEDURE
ALTER PROFILE
ALTER RESOURCE COST
ALTER ROLE
ALTER ROLLBACK SEGMENT
ALTER SEQUENCE
ALTER SESSION
ALTER SNAPSHOT
ALTER SNAPSHOT LOG
。。。。。。。
如果想查询create user的具体用法,可用下面命令
SQL> help create user
CREATE USER
-----------
Use CREATE USER to create a database user, or an account through
which you can log in to the database, and establish the means by
which Oracle permits access by the user. You can optionally
assign the following properties to the user:
* default tablespace
* temporary tablespace
* quotas for allocating space in tablespaces
* profile containing resource limits
CREATE USER user IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS 'CN=user'}
[ DEFAULT TABLESPACE tablespace
| TEMPORARY TABLESPACE tablespace
| QUOTA { integer [K | M] | UNLIMITED } ON tablespace
[ QUOTA { integer [K | M] | UNLIMITED } ON tablespace ] ...
| PROFILE profile
| PASSWORD EXPIRE
| ACCOUNT { LOCK | UNLOCK } ... ]
For detailed information on this command, see the Oracle8 Server SQL
Reference.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10537377/viewspace-610875/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10537377/viewspace-610875/