Datasheet

SQL Fundamentals 11
CHANGE
The CHANGE /old/new command changes an old entry to a new entry. The abbreviated com-
mand is
C. If you omit new, old will be deleted.
SQL> C /<>/=
2* FROM emp WHERE empno = 7926
SQL> C /7926
2* FROM emp WHERE empno =
SQL>
INPUT
The INPUT text command adds a line of text. Its abbreviation is I. If text is omitted, you
can add as many lines you want.
SQL> I
3 7777 AND
4 empno = 4354
5
SQL> I ORDER BY 1
SQL> L
1 SELECT empno, ename
2 FROM emp WHERE empno =
3 7777 AND
4 empno = 4354
5* ORDER BY 1
SQL>
DEL
The DEL command used alone or with * deletes the current line. The DEL m n command
deletes lines from
m through n. If you substitute * for m or n, it implies the current line. The
command
DEL LAST deletes the last line.
SQL> 3
3* 7777 AND
SQL> DEL
SQL> L
1 SELECT empno, ename
2 FROM emp WHERE empno =
3 empno = 4354
4* ORDER BY 1
SQL> DEL 3 *
95127c01.indd 11 2/18/09 6:37:07 AM