Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does one enable the SQL*Plus HELP facility?

April 26, 2017enable facility help

0

Posted

How does one enable the SQL*Plus HELP facility?

1 Answer

0

Posted

To enable HELP for SQl*Plus, run the supplied SQL and Loader scritps to create the Help table and to populate it. Look at this Unix example: cd $ORACLE_HOME/sqlplus/admin/help sqlplus system/manager @helptbl sqlplus system/manager @helpindx sqlldr system/manager control=plushelp.ctl sqlldr system/manager control=sqlhelp.ctl sqlldr system/manager control=plshelp.ctl If the HELP command is not supported on your operating system, you can access the help table with a simple script like this: HELP.SQL: select info from system.