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
Modified date:
17 October 2019
UID
swg21570481