tst> connect system/manager@tst
Connected.
tst> insert into help(topic, seq, info)
   2   select 'TOPICS', (select max(seq)+ 1  from help where topic='TOPICS'), 'MY_COMMAND' from dual -- topic_list
   3   union all
   4   select 'MY_COMMAND',  1 , null from dual union all
   5   select 'MY_COMMAND',  2 , 'MY_COMMAND' from dual union all
   6   select 'MY_COMMAND',  3 , '----------' from dual union all
   7   select 'MY_COMMAND',  4 , null from dual union all
   8   select 'MY_COMMAND',  5 , 'It is my super-puper command.' from dual union all
   9   select 'MY_COMMAND',  6 , null from dual;

 7  rows created.

tst> help my_command

MY_COMMAND
----------

It is my super-puper command.


tst> 

tst> help topics

 Help is available on the following topics:

/
@
...
LIST
MENU
PASSWORD
...
MY_COMMAND

tst> create view topics_tmp as select distinct topic from help;

View created.

tst> delete from help where topic='TOPICS' and substr(info,  1 ,  1 ) != ' ';

 58  rows deleted.

tst> insert into help
   2   select 'TOPICS', rownum+ 10 , topic from topics_tmp;

 58  rows created.

tst> help topics

 Help is available on the following topics:

/
@
@@
...
LIST
MENU
MY_COMMAND
PASSWORD
...
WHENEVER SQLERROR

tst>