Similar to multi-tenant tables, a super tenant can access a multi-tenant sequence owned by a particular tenant using the following functions:
CURRENT-VALUE and DYNAMIC-CURRENT-VALUE function — Provides an option to return the current value of the multi-tenant sequence owned by a specified tenant.
NEXT-VALUE and DYNAMIC-NEXT-VALUE function — Provides an option to return the next value of the multi-tenant sequence owned by a specified tenant.
However, note that if you configure, or ever intend to configure, tables with tenant groups or shared tables in a multi-tenant database, certain uses of a multi-tenant sequences can have unintended consequences, both for regular tenants and super tenant. The following section describes these potential issues.
CURRENT-VALUE and DYNAMIC-CURRENT-VALUE function — Provides an option to return the current value of the multi-tenant sequence owned by a specified tenant.