How can the display row count be set in sqlplus?

2 years ago

Sophia Anderson

1 minute

In sqlplus, you can use the SET PAGESIZE command to determine the number of rows displayed per page.

For example, to set the number of lines displayed per page to 20, you can use the following command:

SET PAGESIZE 20

You can also use the SET LINESIZE command to set the number of characters per line (default is 80 characters).

For example, to set the number of characters per line to 100, you can use the following command:

SET LINESIZE 100

Please note that the line and character settings will only take effect in the current session. If you exit SQLPlus and restart, you will need to set them again.