| Command | Abbreviation | Purpose |
|---|---|---|
APPEND text | A text | adds text at the end of the current line |
CHANGE/old/new | C/old/new | changes old to new in the current line |
CHANGE/text | C/text | deletes text from the current line |
CLEAR BUFFER | CL BUFF | deletes all lines |
DEL | (none) | deletes the current line |
DEL n | (none) | deletes line n |
DEL * | (none) | deletes the current line |
DEL n * | (none) | deletes line n through the current line |
DEL LAST | (none) | deletes the last line |
DEL m n | (none) | deletes a range of lines (m to n) |
DEL * n | (none) | deletes the current line through line n |
INPUT | I | adds one or more lines |
INPUT text | I text | adds a line consisting of text |
LIST | ; or L | lists all lines in the SQL buffer |
LIST n | L n or n | lists line n |
LIST * | L * | lists the current line |
LIST n * | L n * | lists line n through the current line |
LIST LAST | L LAST | lists the last line |
LIST m n | L m n | lists a range of lines (m to n) |
LIST * n | L * n | lists the current line through line n |
Tuesday, June 2, 2009
SQL*Plus Editing Commands
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment