Oracle Database Interview Question:

How To Get Help at the SQL Prompt?

Submitted by: Administrator

Once SQL*Plus is started, you will get a SQL prompt like this: SQL>. This where you can enter commands for SQL*Plus to run.

To get help information at the SQL prompt, you can use the HELP command as shown in the following tutorial example:

SQL> HELP INDEX

Enter Help [topic] for help.
<pre> @ COPY PAUSE SHUTDOWN
@@ DEFINE PRINT SPOOL
/ DEL PROMPT SQLPLUS
ACCEPT DESCRIBE QUIT START
APPEND DISCONNECT RECOVER STARTUP
ARCHIVE LOG EDIT REMARK STORE
ATTRIBUTE EXECUTE REPFOOTER TIMING
BREAK EXIT REPHEADER TTITLE
...
COMPUTE LIST SET XQUERY
CONNECT PASSWORD SHOW</pre>
SQL> HELP CONNECT

CONNECT
-------
Submitted by: Administrator

Connects a given username to the Oracle Database. When you
run a CONNECT command, the site profile, glogin.sql, and
the user profile, login.sql, are processed in that order.
CONNECT does not reprompt for username or password if the
initial connection does not succeed.

CONN[ECT] [{logon|/|proxy} [AS {SYSOPER|SYSDBA}]]

where logon has the following syntax:
username[/password][@connect_identifier]

Submitted by: Administrator