Oracle SQL Plus Pocket Reference, 2nd Edition

Name

LIST

Synopsis

L[IST] [{b | * | LAST}[ {e | * | LAST}]]

The LIST command is an editing command that lists the current line from the buffer. Issuing LIST by itself displays all lines in the buffer. For example:

SQL> L
  1  SELECT
  2  *
  3* FROM dual
SQL> L 2 *
  2  *
  3* FROM dual
SQL> L 1 LAST
  1  SELECT
  2  *
  3* FROM dual

Parameters

b

A line number representing the beginning of a range of lines to list. If no ending line number is specified, only this one line is listed.

e

A line number representing the end of a range of lines to list.

*

Refers to the current line number.

LAST

Refers to the last line in the buffer.