① 以system用户登入
执行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.