How to install help for sqlplus

Source: Internet
Author: User

How to install help for sqlplus


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 shocould 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
Execute the help statement of the attachment.
SQL> @ $ ORACLE_HOME/help. SQL

Usage: for example
SQL> help grant

GRANT (Object Privileges)
-------------------------

Use this command to grant privileges for a special object
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.