How to get help in sql at command prompt

[iyyappan]

Dear Gurus,

How to get help in sql*plus at command prompt.

In Solaris sql> help create table like this. Any parameter set in
init.ora.

The help files is avaliable $ORACLE_HOME/sqlplus/admin/help in my machine.

There are four files in $ORACLE_HOME/sqlplus/admin/help.
1.helpbld.sql
2.helpdrop.sql
3.helplus.sql
4.hlpbld.sql

How to run the files in any order is there? Can u please advise me.

I Use the command

sqlplus system/ @hlpbld.sql helpus.sql

But still i am not get it, My database version is 9.0.1.1.0

with effect from 9i sqlplus help has been discontinued?


Can u please advise me,

Thanks in advance,

Iyyappan.M

[Tarry]

Originally posted by iyyappan

I Use the command

sqlplus system/ @hlpbld.sql helpus.sql

But still i am not get it, My database version is 9.0.1.1.0

with effect from 9i sqlplus help has been discontinued?


Can u please advise me,

Thanks in advance,

Iyyappan.M

I am not sure about discontinuation, you can ,during db creation opt for sql*plus help installation.

comment the full path here...
such as
@D:\Oracle\Ora91\sqlplus\admin\help\helpbld.sql helpus.sqlWhen you do @ it'll look into the sqlpath env variable defined location....

Cheers!!

Tarry

[SANJAY_G]

Here is the procedure to do that.

http://www.orafaq.com/faqplus.htm#HELP

Sanjay

[Tarry]

Iyappan,
What's the error you're getting?
Have you looked in the url which sanjay posted?

paste your actions here?

[iyyappan]

Hi Tarry,

As per rule i run the script. but i got same error.

Error means help not avaliable.

Please advise me,

Thanks in advance,
Iyyappan.M

[Tarry]

Does the script run successfully?

[dba_dada]

cd $oracle_home/sqlplus/admin/help
setenv ORACLE_SID xxx
setenv ORABLE_HOME xxx/xxx/xxx/8.0.5
setenv SYSTEM_PASS system/xxxx
helpins (from $ORACLE_HOME/bin)

Hope this help....