sqlplus help工具

最新推荐文章于 2024-07-02 00:50:11 发布

weixin_30570101

最新推荐文章于 2024-07-02 00:50:11 发布

阅读量109

点赞数

文章标签：数据库 php

原文链接：http://www.cnblogs.com/djinmusic/archive/2012/12/17/2821322.html

版权

翻了一下比较老的帖子 http://www.oracle.com.cn/viewthread.php?tid=1710 ，有个安装SQL*PLUS 的HELP 及 SQL 语法的HELP的帖子，可以实现以下功能

 
         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就可以安装超级帮助。

通过为知笔记发布

附件列表

转载于:https://www.cnblogs.com/djinmusic/archive/2012/12/17/2821322.html

weixin_30570101

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
sqlplus help工具

翻了一下比较老的帖子 http://www.oracle.com.cn/viewthread.php?tid=1710 ，有个安装SQL*PLUS 的HELP 及 SQL 语法的HELP的帖子，可以实现以下功能 1234567891011121314151617181920212223242526SQL> help create userCREATE USER-----------...
复制链接

扫一扫