Select the Data Catalog Locale Selections

The query returns the locale selections that are defined in the Data Catalog Locale Selection function.

The CODE is the locale code. The POSITION is the position number of the locale. The SEARCH_LIST values are the locales used by the query to select localized values. The search list locales are searched in priority order until a value is found. The DEFAULTING value combines two properties. The Default value designates the locale code of the default locale. The default locale is automatically assigned to the locale in position 1. The NoFallback value denotes that if a localized value is not found in the data, the position is empty. The NoFallback option is automatically assigned.


SELECT * from datacatalog.locale_selection