SQL Plus - LIST (the SQL Buffer)

Card Puncher Data Processing


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


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


  • 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

How to

list the whole buffer

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



1* select '&_USER' from dual

Discover More
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - SQL Buffer

The SQL Buffer contains the most recently executed: SQL command or PL/SQL block The buffer has no command history list and does not record SQLPlus commands. at the beginning, just use 0...
Card Puncher Data Processing
SQL Plus - Special Characters

Useful command in sqlplus. The At & character is the default character that define a substitution variable. You can change it with the define system variable. The slash command (/): ...

Share this page:
Follow us:
Task Runner