Tuesday, June 2, 2009

SQL*Plus Editing Commands

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

No comments: