Re: Seeing double in SQLPLUS's HELP

chamblej_at_author.gsfc.nasa.gov (JEFF CHAMBLEE (512)) writes:
>I believe this may have been a recent thread, sorry. Please help.
>When I type HELP in SQLPLUS I see double:
>SQL> help
> HELP
> HELP
[ the rest mercifully deleted. ]
[ the rest mercifully deleted. ]

In addition to checking to see if the SYSTEM.HELP table has been loaded twice, check out how many rows are in the SYSTEM.DUAL table. A few times when I've installed products and then done a full database import, DUAL ends up with TWO rows and causes exactly this behaviour.

A quick test demonstrating the problem:

  SQL> SELECT SYSDATE FROM DUAL;   SYSDATE

  SQL> Hope that helps.

-- 
Andrew Finkenstadt  |  Systems Analyst, Homes & Land Publishing Corporation
+1 904-575-0189     |  GEnie Sysop
andy_at_genie.geis.com |  THE RELATIONAL OATH:  "I promise to use the key, the
andy_at_homes.com      |  whole key, and nothing but the key, so help me Codd."