【www.bbyears.com--ling】
如何给sqlplus 安装help
Installing the Help Facility Manually
The Help Facility may be installed manually using the shell script
$ORACLE_HOME/bin/helpins. Before you run the script, the SYSTEM_PASS environment variable should be set to the SYSTEM schema name and password. For example:
$ setenv SYSTEM_PASS SYSTEM/MANAGER
$ helpins
If the SYSTEM_PASS variable is not set, helpins prompts you for the SYSTEM password and loads the help data into the SYSTEM schema. You can also run $ORACLE_HOME/sqlplus/help/helpbld.sql helpus.sql to install the Help Facility. The system user can run the file helpbld.sql and its argument, helpus.sql, in SQL*Plus to create Help Facility Tables. For example:
$ sqlplus system/manager
SQL> @?/sqlplus/admin/help/helpbld.sql helpus.sql
执行附件的help语句
SQL>@$ORACLE_HOME/help.sql
使用:如
SQL> help grant
GRANT (Object Privileges)
-------------------------
Use this command to grant privileges for a particular object to
users and roles. To grant system privileges and roles, use the GRANT
command (System Privileges and Roles).
GRANT
{ object_priv | ALL [PRIVILEGES] }
[ ( column [, column] ...) ]
[, { object_priv | ALL [PRIVILEGES] }
[ ( column [, column] ...) ] ] ...
ON [ schema.| DIRECTORY] object
TO { user | role | PUBLIC} ...
[ WITH GRANT OPTION]
For detailed information on this command, see the Oracle8 Server SQL
Reference.
GRANT (System Privileges and Roles)
-----------------------------------
Use this command to grant system privileges and roles to users and
roles. To grant object privileges, use the GRANT command (Object
Privileges).
GRANT
{ system_priv | role}
[, { system_priv | role} ] ...
TO
{ user | role | PUBLIC}
[, { user | role | PUBLIC} ] ...
[ WITH ADMIN OPTION]
For detailed information on this comman