sqlplus help工具

翻了一下比​较老的帖子 http://www.oracle.com.cn/viewthread.php?tid=1710 ，有个安装SQL*PLUS 的HELP 及 SQL 语法的HELP的帖子，可以实现以下功能 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
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.
 
直接用system运行@help.sql就可以安装超级帮助。




附件列表

     

    posted on 2012-12-17 10:35  DJ IN MUSIC  阅读(215)  评论(0)    收藏  举报

    导航