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, 1264👍, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...