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).
select * from table(SYS_BOOT.MGMT.BROWSE_TABLE( FOREIGN_SERVER_NAME, PROPOSED_TABLE_OPTIONS, LOCALE_NAME)) );