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

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;