SQLPlus Del

DEL Command Syntax:

DEL [n|n m|n *|n LAST|*|* n|* LAST|LAST]

n = delete line n.
n m = delete lines n through m.
n * = delete line n through the current line.
n LAST = delete line n through the last line.
* = delete the current line.
* n = delete the current line through line n.
* LAST = delete the current line through the last line.
LAST = delete the last line.

DEL Command Examples:

SELECT code, name
FROM customers_view
WHERE customer_type = ‘VIP’
ORDER BY code;

SQL> 3* WHERE customer_type = ‘VIP’
SQL> DEL

Result:
SELECT code, name
FROM customers_view
ORDER BY code;

SQL> DEL 3

Result:
SELECT code, name
FROM customers_view