19.26 UPDATE_TABLE Procedure

This procedure updates the attributes for a blueprint table. The logical key is p_blueprint and p_table_name.

Syntax

APEX_DG_DATA_GEN.UPDATE_TABLE (
    p_blueprint         IN VARCHAR2,
    p_table_name        IN VARCHAR2,
    p_new_table_name    IN VARCHAR2     DEFAULT NULL,
    p_sequence          IN PLS_INTEGER,
    p_preserve_case     IN VARCHAR2     DEFAULT 'N',
    p_display_name      IN VARCHAR2     DEFAULT NULL,
    p_singular_name     IN VARCHAR2     DEFAULT NULL,
    p_plural_name       IN VARCHAR2     DEFAULT NULL,
    p_rows              IN NUMBER       DEFAULT 0,
    p_max_rows          IN VARCHAR2     DEFAULT NULL )

Parameters

Table 19-26 UPDATE_TABLE Parameters

Parameter	Description
p_blueprint	Identifier for the blueprint.
p_table_name	Name of table that can exist or not exist.
p_new_table_name	New table name (rename).
p_sequence	1 for first table, 2 for second, and so forth.
p_preserve_case	Defaults to N which forces p_new_table_name to uppercase. If Y, preserves casing of p_new_table_name.
p_display_name	Friendly display name.
p_singular_name	Singluar friendly name.
p_plural_name	Plural friendly name.
p_rows	Number of rows to generate for this table.
p_max_rows	If NULL, then p_rows determines the number of rows, otherwise random rows between p_rows and p_max_rows are used when generating output.

Example

BEGIN
    apex_dg_data_gen.update_table(
                p_blueprint               => 'Cars',
                p_table_name              => 'MY_CARS',
                p_sequence                => 20,
                p_new_table_name          => 'MY_NEW_CARS',
                p_display_name            => 'My great cars 2',
                p_singular_name           => 'My car',
                p_plural_name             => 'My Cars',
                p_rows                    => '50',
    );
END;

BEGIN
   apex_dg_data_gen.update_table(
                p_blueprint               => 'Cars',
                p_table_name              => 'my_cars',
                p_sequence                => 10,
                p_rows                    => '50',
                p_use_existing_table      => 'Y',
    );
END;