1 Reply Latest reply: Jun 14, 2012 5:09 AM by Ishan RSS

    display sql syntax while in sql plus ?

    935875
      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
          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