Updated on 2024-08-20 GMT+08:00

DB4AI.SAMPLE_SNAPSHOT

SAMPLE_SNAPSHOT is a function that samples basic data to generate snapshots for the DB4AI feature, as described in Table 1. You can call this function by using the SAMPLE SNAPSHOT syntax.

Table 1 DB4AI.SAMPLE_SNAPSHOT input parameters and return values

Parameter

Type

Description

i_schema

IN NAME

Name of the schema storing snapshots.

i_parent

IN NAME

Parent snapshot name.

i_sample_infixes

IN NAME[]

Sample snapshot name infix.

i_sample_ratios

IN NUMBER[]

Size of each sample, which is used as the sample set ratio.

i_stratify

IN NAME[]

Layering strategy.

i_sample_comments

IN TEXT[]

Sample snapshot description.

res

OUT db4ai.snapshot_name

Result.