Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

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 professional 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.

add comment

2 Answers

up vote 0 down vote accepted

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

@%ORACLE_HOME%\SQLPLUS\ADMIN\HELP\HLPBLD.SQL HELPUS.SQL

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

share|improve this answer
add comment

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
add comment

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