Data Generation Functions

normal

Returns a normal distribution Supported Signatures

function normal(double, double, decimal(38, 0)) returns double

🔗 Official Documentation

random

returns a random number sequence Supported Signatures

function random() returns decimal(38, 0)
function random(decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

randstr

Returns a random string of alphanumeric characters Supported Signatures

function randstr(decimal(38, 0), decimal(38, 0)) returns varchar

🔗 Official Documentation

seq1

returns a sequence of 1-byte integers Supported Signatures

function seq1() returns decimal(38, 0)
function seq1(decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

seq2

returns a sequence of 2-byte integers Supported Signatures

function seq2() returns decimal(38, 0)
function seq2(decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

seq4

returns a sequence of 4-byte integers Supported Signatures

function seq4() returns decimal(38, 0)
function seq4(decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

seq8

returns a sequence of 8-byte integers Supported Signatures

function seq8() returns decimal(38, 0)
function seq8(decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

uniform

Returns a uniform random distribution Supported Signatures

function uniform(decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function uniform(double, double, decimal(38, 0)) returns double

🔗 Official Documentation

zipf

Returns a Zipf distribution Supported Signatures

function zipf(double, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation