Using the SQL*Plus Editor
Commands that have been entered into the memory buffer can be modified. SQL*Plus has a series of commands that allow the user to modify buffered commands. This feature is particularly useful when you have entered incorrect commands. Table 2.1 lists the various editing commands.
| Command | Description | Example |
|---|---|---|
| l | Displays the contents of the buffer. | L |
| ln | Displays the target line (n), which will become the current line. | l 4 |
| Linenumber text | Entering a line number followed by text will cause the indicated line to be replaced with the new text. | 2 from department |
| c/old/new | Changes the first occurrence of the old text characters to new text characters for the current line. (A line is made current ... |
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
