Online Documentation for Data Generator for Oracle

BLOB field parameters

A BLOB is a binary large object that can store a variable amount of data. You can generate values for this field randomly or choose to take them from a specified list of files or SQL query, or from an existing table field of the same data type.


The Generation properties panel allows you to define preferences for generating values for BLOB field type.


BLOB field parameters



Select Data generation mode as follows:


RadioButton Generate random data

Set the Min length, Max length values to define the minimum and the maximum length for generated values.


BLOB field parameters - Mode - Random data



RadioButton Get data from files / SQL query

This panel allows you to define the list of files to generate BLOB data from. You can specify the list of files to use their content as values for the BLOB field by selecting the List of Files option.

To add a file, use the btnListAddValue Add Value button.

To load a list of file paths from an existing external file, use the btnListLoadFromFile Load from file button.

To save the list to an external file, use the btnListSaveToFile Save to file button.

To remove a single file, use the btnListDeleteValue Delete Value button.

To remove all items from the list, use the btnListClear Clear button.


You can also specify whether the files are to be taken in random order or in the order they have been inputted.


Alternatively, you can set the SQL query option and input an SQL query into the editor, and the resulting dataset will be used as the list for data generation.


BLOB field parameters - Mode - Files or query



RadioButton Get data from Field

This option allows you to specify a field to generate data from: use the Table and Field drop-down lists to select the source table and field that will be used to take data for generation.


BLOB field parameters - Mode - Field