SQLPlus List

LIST Command Syntax:

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

LIST Command Example:

1 SELECT name, dept_id, role_id
2 FROM users
3 WHERE role_id= ‘MANAGER’
4* ORDER BY dept_id

SQL> LIST 3

Result: 3* WHERE role_id= ‘MANAGER’