BROWSE_TABLE

Returns the set of options relevant to a table created within a given foreign data server. The foreign data server must have already been created. You can pass in a partial set of options via the proposed_table_options cursor parameter, which must have two columns (OPTION_NAME and OPTION_VALUE, in that order). This allows for an incremental interaction, starting with specifying no options, then some, then more, stopping once user and wrapper are both satisfied.

The locale_name parameter can either be the name of the locale for which to return descriptions (such as ‘en_US’), or NULL to use the server’s default locale. The result set is not fully normalized, because some options support a list of choices (such as for a dropdown selection UI widget). optional_choice_ordinal -1 represents the “current” choice (either proposed by the user or chosen as default by the wrapper). Other choice ordinals starting from 0 represent possible choices (if known).

Syntax:

select * from table(SYS_BOOT.MGMT.BROWSE_TABLE(
FOREIGN_SERVER_NAME,
PROPOSED_TABLE_OPTIONS,
LOCALE_NAME))
);

Returns table:

Field Type
option_ordinal integer
option_description varchar(4096)
option_choice_ordinal int