SQL Plus - LIST (the SQL Buffer)

> Procedural Languages > (SQL Plus|SqlCl) (Oracle Database Console)

1 - About

The list command lists one or more lines of the SQL buffer.

Advertising

3 - Syntax

L[IST] [n | n m | n  * | n LAST | * | * n | * LAST | LAST]

where:

  • n is the first line to show
  • m is the last line to show
  • LAST is an alias for the last line of the buffer

4 - How to

4.1 - list the whole buffer

Enter LIST or ; with no clauses to list all lines.

LIST

or

;
  1* select '&_USER' from dual
lang/sqlplus/list.txt · Last modified: 2017/05/09 16:51 by gerardnico