Re: Help in sqlplus

From: S. Anthony Sequeira <Sequeira_at_lineone.net>
Date: Thu, 8 Jun 2000 10:44:20 +0100
Message-Id: <10522.108257@fatcity.com>

Hi,

I am running 8.05 on NT4 SP4.

I have built the help tables, they are there, with the data but whenever I do a help I get:

SQL> help
SQL*Plus Help Files are included in Oracle Documentation. You have to read SQL*Plus Help Files from Oracle Documentation

tonys_at_ajp_laptop2[SAS1]:/orant/plus80/help $ plus80

SQL*Plus: Release 8.0.5.0.0 - Production on Thu Jun 8 10:40:47 2000

Enter user-name: system
Enter password:

Connected to:
Oracle8 Enterprise Edition Release 8.0.5.0.0 - Production With the Partitioning and Objects options PL/SQL Release 8.0.5.0.0 - Production

SQL> select * from help where rownum < 10;

TOPIC                                                    SEQ


-------------------------------------------------- ---------

INFO

ACCEPT                                                     1


ACCEPT                                                     2

ACCEPT

ACCEPT                                                     3

ACCEPT                                                     4


ACCEPT                                                     5

ACCEPT reads a line of input and stores it in a given user variable.

ACCEPT                                                     6


ACCEPT                                                     7

TOPIC                                                    SEQ


-------------------------------------------------- ---------

INFO

ACC[EPT] variable [NUM[BER]|CHAR|DATE] [FOR[MAT] format]

ACCEPT                                                     8

[DEF[AULT] default] [PROMPT text|NOPR[OMPT]] [HIDE]

ACCEPT                                                     9

9 rows selected.

SQL> help accept
SQL*Plus Help Files are included in Oracle Documentation. You have to read SQL*Plus Help Files from Oracle Documentation. SQL> desc help

 Name                            Null?    Type
 ------------------------------- -------- ----
 TOPIC                           NOT NULL VARCHAR2(50)
 SEQ                             NOT NULL NUMBER
 INFO                                     VARCHAR2(80)

SQL> select count(*) from help;

COUNT(*)

5085

SQL> Can anyone help? (Pun intended).

Regards.

Tony

--
S. Anthony Sequeira

Wait for the ricochet

Opinions expressed herein are my own and do
not necessarily represent those of my employer
----- Original Message -----
From: Jonathan Gennick <jonathan_at_gennick.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: 07 June 2000 18:38
Subject: Re: Help in sqlplus

On Wed, 07 Jun 2000 08:31:02 -0800, Ruth Gramolini wrote:

>How do you create the help tables on the server and client for
SQL*PLUS. I
>know that this is a simple question but I am a simple person.

I'm running 8.1.5, and I have a directory named
$ORACLE_HOME/sqlplus/admin/help. In that directory are the
files needed to load the help table used by SQL*PLus. My
Windows NT system contains file named helpinst.txt that
contains instructions for using SQL*Loader to load the help
data. On my Linux box I don't have the helpinst.txt file,
just the plushelp.ctl file used to load the help table. I
believe that you need to log in as SYSTEM, run helptbl.sql,
then helpindx.sql, and then use SQL*Loader to load the
actual data from plushelp.ctl.

Beginning with release 8.1, the SQL*Plus help table no
longer contains help for PL/SQL and SQL statements. It now
only documents SQL*Plus commands.

regards,

Jonathan

_____________________________________________________
jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are
--
Author: Jonathan Gennick
  INET: jonathan_at_gennick.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

Received on Thu Jun 08 2000 - 04:44:20 CDT