RESEQUENCE_BLUEPRINT Procedure

24.21 RESEQUENCE_BLUEPRINT Procedure

This procedure resequences all tables and columns within tables with gaps of p_offset, retaining their current order.

Syntax

APEX_DG_DATA_GEN.RESEQUENCE_BLUEPRINT (
    p_blueprint IN VARCHAR2,
    p_offset    IN NUMBER   DEFAULT c_default_seq_offset )

Parameters

Parameter	Description
`p_blueprint`	Identifier for the blueprint.
`p_offset`	The offset between gaps, such as `10`, `100`, or `1000`.

Example

BEGIN
  apex_dg_data_gen.resequence_blueprint(
               p_blueprint          => 'Cars',
               p_offset             => 100);
END;

Parent topic: APEX_DG_DATA_GEN