在sqlplus中使用帮助系统

Oracle SQL Plus 命令详解

最新推荐文章于 2025-11-26 14:12:29 发布

最新推荐文章于 2025-11-26 14:12:29 发布 · 166 阅读

文章标签：

#数据库

本文介绍如何使用system用户登录Oracle，并通过SQL Plus执行helpbld.sql脚本以获取帮助信息。此外，还详细解释了ALTER SESSION命令的各种选项及其用途。

① 以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.