No HELP available 
Author Message
 No HELP available

Using Oracle 8i, with the HELP table filled via the default script
(helpins):

SQL> help select
SP2-0172: No HELP available.

And yet:

SQL> help accept

 ACCEPT
 ------

 [snip]

How do I get the SQL help loaded, like we used to have with Oracle7?

--
The wheel is turning but the hamster is dead.




Wed, 18 Jun 1902 08:00:00 GMT
 No HELP available

Would it be dangerous to export the HELP table from 7.3 and then
import it in 8i?  :)

Quote:
> In version 8 and up, the help command  nolonger contains SQL or PLSQL
> information.  It only covers sqlplus commands.  You might try the SQL
> Language Reference manual.

> Hope that helps!

> > Using Oracle 8i, with the HELP table filled via the default script
> > (helpins):

> > SQL> help select
> > SP2-0172: No HELP available.

> > And yet:

> > SQL> help accept

> > ACCEPT
> > ------

> > [snip]

> > How do I get the SQL help loaded, like we used to have with Oracle7?

> > --
> > The wheel is turning but the hamster is dead.


> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
The wheel is turning but the hamster is dead.




Wed, 18 Jun 1902 08:00:00 GMT
 No HELP available
In version 8 and up, the help command  nolonger contains SQL or PLSQL
information.  It only covers sqlplus commands.  You might try the SQL
Language Reference manual.

Hope that helps!

Quote:
> Using Oracle 8i, with the HELP table filled via the default script
> (helpins):

> SQL> help select
> SP2-0172: No HELP available.

> And yet:

> SQL> help accept

> ACCEPT
> ------

> [snip]

> How do I get the SQL help loaded, like we used to have with Oracle7?

> --
> The wheel is turning but the hamster is dead.



Sent via Deja.com http://www.deja.com/
Before you buy.


Wed, 18 Jun 1902 08:00:00 GMT
 No HELP available
It isn't true.
In my 8.0.5 site (Linux) I can get help about sql select, pl/sql select into
and sql*plus accept from sqlplus. At same time my Windows SQL*Plus doesn't
help me. But I can issue
SELECT INFO FROM SYSTEM.HELP WHERE UPPER(TOPIC) LIKE &1 ORDER BY TOPIC,SEQ;
and get what I need anyway.
Good luck!
Quote:
> In version 8 and up, the help command  nolonger contains SQL or PLSQL
> information.  It only covers sqlplus commands.  You might try the SQL
> Language Reference manual.

> Hope that helps!

> > Using Oracle 8i, with the HELP table filled via the default script
> > (helpins):

> > SQL> help select
> > SP2-0172: No HELP available.

> > And yet:

> > SQL> help accept

> > ACCEPT
> > ------

> > [snip]

> > How do I get the SQL help loaded, like we used to have with Oracle7?

> > --
> > The wheel is turning but the hamster is dead.


> Sent via Deja.com http://www.deja.com/
> Before you buy.



Wed, 18 Jun 1902 08:00:00 GMT
 No HELP available
The syntax of Oracle8i and Oracle7 commands are different. After importing
(maybe into your own table with synonym system.help on it) you can add
column version and later use both help information (and even compare them
:-).
Quote:

> Would it be dangerous to export the HELP table from 7.3 and then
> import it in 8i?  :)

> > In version 8 and up, the help command  nolonger contains SQL or PLSQL
> > information.  It only covers sqlplus commands.  You might try the SQL
> > Language Reference manual.

> > Hope that helps!

> > > Using Oracle 8i, with the HELP table filled via the default script
> > > (helpins):

> > > SQL> help select
> > > SP2-0172: No HELP available.

> > > And yet:

> > > SQL> help accept

> > > ACCEPT
> > > ------

> > > [snip]

> > > How do I get the SQL help loaded, like we used to have with Oracle7?

> > > --
> > > The wheel is turning but the hamster is dead.


> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

> --
> The wheel is turning but the hamster is dead.





Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Oracle DBA available, Chicago Metro available

2. Available Contract Candidates Available, Incl. PeopleSoft and Oracle

3. Available Contract Candidates Available, Incl. PeopleSoft and Oracle

4. help,help,help,help,help,help,help,help,help,help,help,help,help,

5. Help!!!, the list of servers for this workgroup is not currently available

6. Upgrade not available from 2 to 2000 - Help!

7. Please help - [Microsoft][SQLServer JDBC Driver]No more data available to read

8. Log Space Available SQL 6.5 - help

9. Help: Problems with Event Logging - Descriptions Not Available

10. Cannot attach db after trying all available measures any help

11. Not enough storage is available to process this command - Help

12. Help: HTML Edit Control available???


 
Powered by phpBB® Forum Software