This discussion is archived
1 Reply Latest reply: Jun 14, 2012 3:09 AM by Ishan RSS

display sql syntax while in sql plus ?

935875 Newbie
Currently Being Moderated
What is in Oracle's sqlplus equivalent of Linux's man or --help ?

When I'm in sqlplus and type help index, I get some commands displayed, but there is no way to get specific sql syntax. For example if I type 'help select' I get:

SP2-0172 No HELP matching this tiopic was found.

Of course, I would like to get all available options for select command.

How can I get info or sql syntax while I'm at sql prompt ?

Thanks
  • 1. Re: display sql syntax while in sql plus ?
    Ishan Journeyer
    Currently Being Moderated
    Please go through this for syntax reference.

    http://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm

    There is no way to display syntax help while in SQL plus.

    The above link is an exhaustive course. If you are stuck somewhere and in there is a time constraint, internet is the best option. there are plenty of resources available.

    Edited by: Ishan on Jun 14, 2012 3:36 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points