select default_name, iso from countries order by default_name select label, coalesce(iso_639_1, iso_639_2) from language_639_2_codes order by label select count(*) from ad_locales where language = :language and default_p = 't' insert into ad_locales ( locale, language, country, variant, label, nls_language, nls_territory, nls_charset, mime_charset, default_p, enabled_p ) values ( :locale, :language, :country, NULL, :label, :nls_language, :nls_territory, :nls_charset, :mime_charset, :default_p, 'f' )