12.18 DEL
Syntax
DEL [n | n m | n * | n LAST | * | * n | * LAST | LAST]
Terms
Term | Description |
---|---|
n |
|
n m |
|
n * |
Deletes line n through the current line. |
n LAST |
Deletes line n through the last line. |
* |
|
* n |
Deletes the current line through line n. |
* LAST |
Deletes the current line through the last line. |
LAST |
Enter DEL with no clauses to delete the current line of the buffer.
Usage
DEL makes the following line of the buffer (if any) the current line. You can enter DEL several times to delete several consecutive lines.
Note:
DEL is a SQL*Plus command and DELETE is a SQL command. For more information about the SQL DELETE command, see DELETE.
Examples
Assume the SQL buffer contains the following query:
SELECT LAST_NAME, DEPARTMENT_ID FROM EMP_DETAILS_VIEW WHERE JOB_ID = 'SA_MAN' ORDER BY DEPARTMENT_ID;
To make the line containing the WHERE clause the current line, you could enter
LIST 3
3* WHERE JOB_ID = 'SA_MAN'
followed by
DEL
The SQL buffer now contains the following lines:
SELECT LAST_NAME, DEPARTMENT_ID FROM EMP_DETAILS_VIEW ORDER BY DEPARTMENT_ID
To delete the third line of the buffer, enter
DEL 3
The SQL buffer now contains the following lines:
SELECT LAST_NAME, DEPARTMENT_ID
FROM EMP_DETAILS_VIEW