O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table 2.1. SQL Plus Editor 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required