19.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

Table 19-21 RESEQUENCE_BLUEPRINT 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;