Collections:
Help at the SQL Prompt in Oracle
How To Get Help at the SQL Prompt in Oracle?
✍: FYIcenter.com
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. @ 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 SQL> HELP CONNECT CONNECT ------- 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 prompt 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]
2020-08-25, 798👍, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...