Inline Dataset

You can use an inline dataset to embed a static table of hard-coded values directly in your Data Augmentation Scripts program without having to import a source or warehouse table.

The INLINE table type requires instructions for the table structure and a set of records as input. The table is then generated and loaded with the provided data.

Example:

DEFINE INLINE DATASET MYINLINEDATA   
    ROWSOURCE INTABLE([PROMO_CATEGORY_ID:NUMBER,PROMO_CATEGORY:VARCHAR2(128)]
               VALUES
                    ([2 ,'NO PROMOTION'],
                     [3 ,'TV'],
                     [4 ,'ad news']
                     )
                    );
    PRIMARYKEY [PROMO_CATEGORY_ID];
 END
 
 DEFINE DATASET PROMOTION_CATEGORY_D
    ROWSOURCE MYINLINEDATA;
    THIS = MYINLINEDATA;
 END

The output is shown in the PROMOTION_CATEGORY_D table:

PROMO_CATEGORY_ID (NUMBER) PK	PROMO_CATEGORY (VARCHAR2)
2	NO_PROMOTION
3	TV
4	ad news