RE: SQL*PLUS Help

From: Jain, Akshay <Akshay.Jain_at_cit.com>
Date: Fri, 14 Jul 2000 13:14:41 -0400
Message-Id: <10558.112088@fatcity.com>

Apparently NT SQL*Plus does not query the HELP table like UNIX does.

Thus you need something like

-- ==============================================================

set serveroutput on size 100000

set heading off
set pagesize 0
set verify off

Show help information on topic entered on command line.

declare

Find each topic like the string entered. cursor crsr_topic is select distinct topic from help where upper(topic) like upper('%&1%');
For the given topic, show the information lines. cursor crsr_info(p_topic varchar2) is select info from help where topic = p_topic order by seq;

begin

Show help on every topic that matches the input pattern. for cur_topic in crsr_topic loop

		dbms_output.put_line(cur_topic.topic);
		dbms_output.put_line('====================');

		-- Show help information on the topic.
		for cur_line in crsr_info(cur_topic.topic) loop
			dbms_output.put_line(cur_line.info);
		end loop;
	
dbms_output.put_line('-------------------------------------');

	end loop;

exception

	when others then
		dbms_output.put_line('Help error:' || sqlerrm);

end;
/

set heading on
set pagesize 20
set verify on

-- ==============================================================

This would be best put into a script with a &1 input. Then you could run "@help select" etc.

Akshay Jain

Newcourt-CIT
Tel. (416) 507-5385
mailto:Akshay.Jain_at_cit.com

-----Original Message-----
From: Charlie Mengler [mailto:charliem_at_mwh.com] Sent: Friday, July 14, 2000 11:27 AM
To: Multiple recipients of list ORACLE-L Subject: Re: SQL*PLUS Help

I do THANK all those who replied, but now I have a different question that is directly related to my initial query.

On V7.3.4 in SQL*Plus you could do
SQL> HELP SELECT
and this would display a nice long description of the SELECT statement.

After running the helpins against an V8.1.6 DB, I can no longer do HELP SELECT. :-( or get "help" on any SQL statement. Is there something else I need to do in order to be able to get "help" on SQL statements while inside SQL*Plus?

TIA!

"Gurgaon, DBA (CAP, GECSI, CONTRACTOR)" wrote:

> 
> set SYSTEM_PASS parameter as given below
> $SYSTEM_PASS=system/password
> $export SYSTEM_PASS
> Now run helpins which is present in ORACLE_HOME/bin
> $./helpins
> 
> This procedure is in the case of UNIX.
> 
> Vikas
> -----Original Message-----
> Sent: Friday, July 14, 2000 3:49 AM
> To: Multiple recipients of list ORACLE-L
> 
> I know this has been asked & answer a few times this year.
> But I'm having a major attack of senility.
> 
> How do I get online HELP installed in SQL*PLUS?
> 
> I've even tried searching the online Doc. Set,
> but have not been able to find the right page.
> 
> --
> Charlie Mengler                               Maintenance Warehouse
> charliem_at_mwh.com                              5505 Morehouse Drive
> 858-552-6229                                  San Diego, CA 92121
> There is a fine line between vision & hallucination. Don't cross it!
> --
> Author: Charlie Mengler
>   INET: charliem_at_mwh.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
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Gurgaon, DBA (CAP, GECSI, CONTRACTOR)
>   INET: DBA.Gurgaon_at_geind.GE.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
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler                               Maintenance Warehouse  
charliem_at_mwh.com                              5505 Morehouse Drive   
858-552-6229                                  San Diego, CA 92121

There is a fine line between vision & hallucination. Don't cross it!

-- 
Author: Charlie Mengler
  INET: charliem_at_mwh.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 Fri Jul 14 2000 - 12:14:41 CDT