About cookies on this site Our websites require some cookies to function properly (required). In addition, other cookies may be used with your consent to analyze site usage, improve the user experience and for advertising. For more information, please review your options. By visiting our website, you agree to our processing of information as described in IBM’sprivacy statement. To provide a smooth navigation, your cookie preferences will be shared across the IBM web domains listed here.
Question & Answer
Question
How do I navigate Oracle SQL*Plus?
Answer
A list of commonly-used commands for Oracle SQL*Plus.
SQL*Plus is very similar in appearance to nzsql. However, the commands are quite different. The most common SQL*Plus commands are as follows:
| Function | Command |
| Log in | sqlplus [username]/[password] |
| Send output to file | SPOOL [filename] |
| Help on set commands | HELP SET |
| Help on miscellaneous commands (like nzsql \\?) | HELP INDEX |
| Describe object (like nzsql \\d [object name]) | desc [object name] |
| List all my tables (like nzsql \\d) | SELECT tname FROM tab; |
| List all objects to which I have access | SELECT * FROM all_objects; |
| Repeat last command | / |
| Run external file | @[file name] |
| Edit last command with default editor | ed |
| Exit sqlplus | exit |
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ976261
Was this topic helpful?
Document Information
More support for:
IBM PureData System
Software version:
1.0.0
Document number:
462763
Modified date:
17 October 2019
UID
swg21570481
