QUA_CONNECTIONSHUFFLEKEY

QUA_CONNECTIONSHUFFLEKEY#

Gets the pseudonymization seed configured on a connection. This function is commonly used in conjunction with QUA_SHUFFLE and QUA_DESHUFFLE functions.

Syntax#

QUA_CONNECTIONSHUFFLEKEY ( 'connection_name' )

Arguments#

connection_name

Is the name of the connection whose pseudonymization seed is returned.

Return types#

Returns an int value - the connection’s pseudonymization seed - if the calling user has the necessary permission to obtain that information.

Examples#

SELECT qua_connectionshufflekey('oracle_connection') as id;

See also#