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 ?

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

    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


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