Navigation and Display

This section provides information on DBTools console layout such as page, column and console display.

Change Page or Column

For results that cannot be displayed on a single page or on a single column (by default 20 lines are being displayed per page and a line is 80 characters long), you have the ability to navigate between pages by using the following commands:

• f to go one page forward.
• b to go one page backward
• sr to scroll right to next column
• sl to scroll left to previous column

Change Console Display

When displaying a result you have the ability to fix the first line and the first column of the data being displayed for all the pages and columns. It is useful in case of SQL SELECT where you may stick with the first line that displays column names and the first column that displays the record ID.

By default, DBTools console splits result into columns in cases where the record to be displayed is too large to fit on one unique column. You can use the following commands to disable that functionality to have your record displayed on a single column:

• hc to enable / disable first fixed column
• hl to enable / disable first fixed line
• cm to enable / disable column mode