Basic Oracle Concepts and Programming Question: Download Questions PDF
How To Get Help at the SQL Prompt?
Answers:
Answer #1Once 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
-------
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
-------
Answer #2Connects 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]
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]
Download Oracle Database Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Start the Command-Line SQL*Plus? | What Information Is Needed to Connect SQL*Plus an Oracle Server? |