Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 ?


share|improve this question

closed as off topic by wfaulk, Shane Madden, voretaq7 Dec 16 '12 at 19:23

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 0 down vote accepted

You need to install this feature, log in with SYSTEM account and run this SQL script:


After HLPBLD.SQL run, you have created the help tables on SQL-Plus.

share|improve this answer

You actually seem not to need a help for sqlplus itself, but for the SELECT-statement.

There is not a proper way to get help on query syntax inside the sqlplus, instead I recommend Oracle's documentation site and in this case this page.

(Older Oracle-versions have their own documentations there too)

In practice the official documentation may be too comprehensive to get things done, so, keep Google as a close friend also.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.