Database Studio Preferences: Query Result

Limit for LOB columns (Bytes)

Maximum number of bytes that Database Studio should load from the database for one LOB column

Limit for zoom (Bytes)

Maximum number of bytes that Database Studio should display when you zoom in the LOB column of a results table

Replace non chars in LOB columns

Characters in LOB columns that cannot be displayed are replaced by blanks

Append exported data to file

When you export a result table to a file, the system attaches the content of this result table to the existing file content.

Display char byte value as hex

Database Studio displays data of the data type CHAR BYTE as hexadecimal digits. If you do not choose this option, Database Studio displays this data in binary format.

Determine last row in result

Determines whether Database Studio defines the number of result rows before a results table is displayed

Format values

Specifies whether country-specific formatting is applied to numeric values, dates and so on.

Display the duration of fetching a result row

-

Representation of null value

Characters with which Database Studio displays NULL values

Use forward only result cursor

For fetching results, Database Studio uses a forward-only cursor.

Separate exported data with

Separators between values exported from the SQL editor

Max. displayed rows in result

-