Re: Personal Oracle 7 & SQL*lus 3.1

From: Richard D Holowczak <holowcza_at_andromeda.rutgers.edu>
Date: 24 Feb 1995 09:43:45 -0500
Message-ID: <3ikrb1$eob_at_andromeda.rutgers.edu>

If you are looking for how to "run" SQL*Plus, there is not much to it. If you are looking for help on SQL and/or help on SQL*Plus specific commands such as SAVE, BREAK, TITLE, etc. then you can get this help on-line while running SQL*Plus.

If it is installed correctly, one can get help on any SQL or SQL*Plus command by typing:

           HELP command_name

for example:

          HELP SELECT yields:

                                 SELECT
                                                           SQL statement

 SELECT ALL | DISTINCT * | table.* | expr alias,...

    FROM user.table, table alias,...
    WHERE condition

    CONNECT BY condition  START WITH condition      See: bnf syntax
    GROUP BY expr, expr... HAVING condition              uses of select
    UNION | INTERSECT | MINUS  SELECT...                 query
    ORDER BY expr | ASC | DESC,...                       subquery
    FOR UPDATE OF column, column... NOWAIT;              from
                                                         where
 SELECT retrieves rows and columns from one or           aliases
 more tables. By itself, a SELECT statement is           connect by
 a query; it is a subquery when it is a clause           group by
 in another statement.   FROM is required; all           order by
 other clauses are optional.   Clauses must be           for update of
 in the order shown above when used together.            set operators
                                                         other operators
 For more information, enter h, space, and one           expressions
 of the topics listed at the right.                      conditions
                                                         example query
 See also: commands, menu.                               example subquery

etc.

At least this is how things work in all of the versions I've used.

I hope this helps a bit . . .

Rich Holowczak
Rutgers University
holowcza_at_andromeda.rutgers.edu Received on Fri Feb 24 1995 - 15:43:45 CET