How To Get Help at the SQL Prompt?
Submitted by: AdministratorOnce 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
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
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
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
☺ | How To Run SQL*Plus Commands in SQL Developer? |
☺ | How Run SQL*Plus Commands That Are Stored in a Local File? |
☺ | What Is Input Buffer in SQL*Plus? |
☺ | What Happens to Indexes If You Drop a Table? |
☺ | How To Call a Stored Function in Oracle? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Oracle RMAN Interview Questions. |