SQL*Plus User's Guide and Reference Release 8.1.6 A75664-01 |
|
Command Reference, 29 of 52
Lists one or more lines of the SQL buffer.
L[IST] [n|n m|n *|n LAST|*|* n|* LAST|LAST]
Refer to the following list for a description of each term or clause:
Enter LIST with no clauses to list all lines.
The last line listed becomes the new current line (marked by an asterisk).
To list the contents of the buffer, enter
SQL> LIST
You will see a listing of all lines in the buffer, similar to the following example:
1 SELECT ENAME, DEPTNO, JOB 2 FROM EMP 3 WHERE JOB = 'CLERK' 4* ORDER BY DEPTNO
The asterisk indicates that line 4 is the current line.
To list the second line only, enter
SQL> LIST 2
You will then see this:
2* FROM EMP
To list the current line (now line 2) to the last line, enter
SQL> LIST * LAST
You will then see this:
2 FROM EMP 3 WHERE JOB = 'CLERK' 4* ORDER BY DEPTNO
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|