ITPub博客

首页 > 数据库 > Oracle > 在sqlplus中使用帮助系统

在sqlplus中使用帮助系统

原创 Oracle 作者:幕南风 时间:2014-07-03 13:43:28 0 删除 编辑

       ① 以system用户登入


       ② 到/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/help
            执行helpbld.sql
            这时会有两个输入值
            第一个是:/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/help
            第二个是:执行help.sql
            help.sql从哪里来呢?

            把路飞的图片下载,打开WinRAR,点击“文件→打开”,然后选择文件类型为“所有文件”,找到 路飞.jpg,就O了

            附上路飞美照:

                                    



       ③ 测试一下:

hr@ORCL> help alter session;

 ALTER SESSION
 -------------

 Use this command to alter your current session in one of the
 following:

   *  to enable or disable the SQL trace facility
   *  to enable or disable global name resolution
   *  to change the values of NLS parameters
   *  to change your DBMS session label in Trusted Oracle
   *  to change the default label format for your session
   *  to specify the size of the cache used to hold frequently used
      cursors
   *  to enable or disable the closing of cached cursors on COMMIT or
      ROLLBACK
   *  in a parallel server, to indicate that the session must access
      database files as if the session was connected to another
      instance
   *  to enable, disable, and change the behavior of hash join
      operations
   *  to change the handling of remote procedure call dependencies
   *  to change transaction level handling
   *  to close a database link
   *  to send advice to remote databases for forcing an in-doubt
      distributed transaction
   *  to permit or prohibit stored procedures and functions from
      issuing COMMIT and ROLLBACK statements
   *  to change the goal of the cost-based optimization approach
   *  in a parallel server, to enable DML statements to be considered
      for parallel execution
   *  to insert, update, or delete from tables with indexes or index
      partitions marked as unusable
   *  to allow deferrable constraints to be checked either
      immediately following every DML statement or at the end of a
      transaction

 ALTER SESSION
   {SET { {SQL_TRACE | GLOBAL_NAMES | SKIP_UNUSABLE_INDEXES}={TRUE |
     FALSE}
        | NLS_LANGUAGE = language
        | NLS_TERRITORY = territory
        | NLS_DATE_FORMAT = \'fmt\'
        | NLS_DATE_LANGUAGE = language
        | NLS_NUMERIC_CHARACTERS = \'text\'
        | NLS_ISO_CURRENCY = territory
        | NLS_CURRENCY = \'text\'
        | NLS_SORT = {sort | BINARY}
        | NLS_CALENDAR = \'text\'
        | LABEL = {\'text\' | DBHIGH | DBLOW | OSLABEL}
        | MLS_LABEL_FORMAT = fmt
        | OPTIMIZER_GOAL = {ALL_ROWS | FIRST_ROWS | RULE | CHOOSE}
        | FLAGGER = {ENTRY | INTERMEDIATE | FULL | OFF}
        | SESSION_CACHED_CURSORS = integer
        | CLOSE_CACHED_OPEN_CURSORS = {TRUE | FALSE}
        | INSTANCE = integer
        | HASH_AREA_SIZE = integer
        | HASH_MULTILBLOCK_IO_COUNT = integer
        | REMOTE_DEPENDENCIES_MODE = {TIMESTAMP | SIGNATURE}
        | ISOLATION_LEVEL {SERIALIZABLE | READ COMMITTED}
        | CONSTRAINT[S] = {IMMEDIATE | DEFERRED | DEFAULT} } ...
   | CLOSE DATABASE LINK dblink
   | ADVISE {COMMIT | ROLLBACK | NOTHING}
   | {ENABLE | DISABLE} COMMIT IN PROCEDURE}
   | {ENABLE | DISABLE} PARALLEL DML

 For detailed information on this command, see the Oracle8 Server SQL
 Reference.


<!-- Baidu Button BEGIN -->

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/26515977/viewspace-1207958/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: PL/SQL每日一题:含有NULL的IF条件
下一篇: 异常的定义、抛出和处理
请登录后发表评论 登录
全部评论
腾讯数据库工程师

注册时间:2012-05-10

最新文章