LIST CLPPlus command
The LIST line-editor command displays all of the lines or a range of lines in the SQL buffer.
Invocation
You must run this command from the CLPPlus interface.
Authorization
None
Required connection
None
Command syntax
Command parameters
-
n
- Displays the specified line in the SQL buffer.
-
n m
- Displays the specified range of lines in the SQL buffer, where the value of m is greater than the value of n.
-
*
- Displays the current line in the SQL buffer.
-
LAST | L
- Displays the last line in the SQL buffer.
Example
In the following example, the L command
used to show line buffer contents.
SQL> LIST
1 SELECT
2 *
3 FROM
4* EMPLOYEE
SQL> L2
2* *
SQL> L4
4* EMPLOYEE
SQL> L5
DB250400E: The buffer line number is invalid. Valid values can be between '1' and '4'.
SQL>In the following example, a variant of the LIST command
is used to show line buffer contents.
SQL> begin
2 dbms_output.put_line('list command ');
3 end;
4 /
DB250000I: The command completed successfully.
SQL> list
1 begin
2 dbms_output.put_line('list command ');
3* end
SQL> 2
2* dbms_output.put_line('list command ');
SQL>