Oracle: V$NLS_VALID_VALUES

select
  'nls_' || lower(parameter)  parameter_name,
   lower(isdeprecated)        is_deprecated,
   listagg(lower(value),',') within group(order by value) parameter_values
from
  v$nls_valid_values
group by
  parameter,
  isdeprecated
order by
  1,
  2;
--
-- nls_characterset 	 false 	 al16utf16,al32utf8,ar8ados710,ar8ados720,ar8aptec715,ar8arabicmac,ar8arabicmacs,ar8asmo8x,ar8ebcdic420s,ar8ebcdicx,ar8iso8859p6,ar8mswin1256,ar8mussad768,ar8nafitha711,ar8nafitha721,ar8sakhr706,ar8sakhr707,az8iso8859p9e,bg8mswin,bg8pc437s,blt8cp921,blt8ebcdic1112,blt8ebcdic1112s,blt8iso8859p13,blt8mswin1257,blt8pc775,bn8bscii,cdn8pc863,ce8bs2000,cel8iso8859p14,ch7dec,cl8bs2000,cl8ebcdic1025,cl8ebcdic1025c,cl8ebcdic1025r,cl8ebcdic1025s,cl8ebcdic1025x,cl8ebcdic1158,cl8ebcdic1158r,cl8iso8859p5,cl8isoir111,cl8koi8r,cl8koi8u,cl8maccyrillic,cl8maccyrillics,cl8mswin1251,d7dec,d7siemens9780x,d8bs2000,d8ebcdic1141,d8ebcdic273,dk7siemens9780x,dk8bs2000,dk8ebcdic1142,dk8ebcdic277,e7dec,e7siemens9780x,e8bs2000,ee8bs2000,ee8ebcdic870,ee8ebcdic870c,ee8ebcdic870s,ee8iso8859p2,ee8macce,ee8macces,ee8maccroatian,ee8maccroatians,ee8mswin1250,ee8pc852,eec8euroasci,eec8europa3,el8dec,el8ebcdic423r,el8ebcdic875,el8ebcdic875r,el8gcos7,el8iso8859p7,el8macgreek,el8macgreeks,el8mswin1253,el8pc437s,el8pc737,el8pc851,el8pc869,et8mswin923,f7dec,f7siemens9780x,f8bs2000,f8ebcdic1147,f8ebcdic297,hu8abmod,hu8cwi2,i7dec,i7siemens9780x,i8ebcdic1144,i8ebcdic280,in8iscii,is8macicelandic,is8macicelandics,is8pc861,iw7is960,iw8ebcdic1086,iw8ebcdic424,iw8ebcdic424s,iw8iso8859p8,iw8machebrew,iw8machebrews,iw8mswin1255,iw8pc1507,ja16dbcs,ja16ebcdic930,ja16euc,ja16euctilde,ja16eucyen,ja16macsjis,ja16sjis,ja16sjistilde,ja16sjisyen,ja16vms,ko16dbcs,ko16ksc5601,ko16ksccs,ko16mswin949,la8iso6937,la8passport,lt8mswin921,lt8pc772,lt8pc774,lv8pc1117,lv8pc8lr,lv8rst104090,n7siemens9780x,n8pc865,ndk7dec,ne8iso8859p10,nee8iso8859p4,nl7dec,ru8besta,ru8pc855,ru8pc866,s7dec,s7siemens9780x,s8bs2000,s8ebcdic1143,s8ebcdic278,se8iso8859p3,sf7ascii,sf7dec,th8macthai,th8macthais,th8tisascii,th8tisebcdic,th8tisebcdics,tr7dec,tr8dec,tr8ebcdic1026,tr8ebcdic1026s,tr8macturkish,tr8macturkishs,tr8mswin1254,tr8pc857,us7ascii,us8bs2000,us8icl,us8pc437,utf8,utfe,vn8mswin1258,vn8vn3,we8bs2000,we8bs2000e,we8bs2000l5,we8dec,we8dg,we8ebcdic1047,we8ebcdic1047e,we8ebcdic1140,we8ebcdic1140c,we8ebcdic1145,we8ebcdic1146,we8ebcdic1148,we8ebcdic1148c,we8ebcdic284,we8ebcdic285,we8ebcdic37,we8ebcdic37c,we8ebcdic500,we8ebcdic500c,we8ebcdic871,we8ebcdic924,we8gcos7,we8hp,we8icl,we8iso8859p1,we8iso8859p15,we8iso8859p9,we8isoicluk,we8macroman8,we8macroman8s,we8mswin1252,we8ncr4970,we8nextstep,we8pc850,we8pc858,we8pc860,we8roman8,yug7ascii,zhs16cgb231280,zhs16dbcs,zhs16gbk,zhs16maccgb231280,zhs32gb18030,zht16big5,zht16ccdc,zht16dbcs,zht16dbt,zht16hkscs,zht16hkscs31,zht16mswin950,zht32euc,zht32sops,zht32tris
-- nls_characterset 	 true  	 al24utffss,ar8ados710t,ar8ados720t,ar8aptec715t,ar8arabicmact,ar8asmo708plus,ar8hparabic8t,ar8mussad768t,ar8nafitha711t,ar8nafitha721t,ar8sakhr707t,ar8xbasic,el8ebcdic875s,ja16dbcsfixed,ja16eucfixed,ja16sjisfixed,ko16dbcsfixed,ko16ksc5601fixed,zhs16cgb231280fixed,zhs16dbcsfixed,zhs16gbkfixed,zht16big5fixed,zht16dbcsfixed,zht32eucfixed,zht32trisfixed
-- nls_language     	 false 	 albanian,american,arabic,assamese,azerbaijani,bangla,belarusian,brazilian portuguese,bulgarian,canadian french,catalan,croatian,cyrillic kazakh,cyrillic serbian,cyrillic uzbek,czech,danish,dutch,egyptian,english,estonian,finnish,french,german,german din,greek,gujarati,hebrew,hindi,hungarian,icelandic,indonesian,irish,italian,japanese,kannada,korean,latin american spanish,latin serbian,latin uzbek,latvian,lithuanian,macedonian,malay,malayalam,marathi,mexican spanish,norwegian,oriya,polish,portuguese,punjabi,romanian,russian,simplified chinese,slovak,slovenian,spanish,swedish,tamil,telugu,thai,traditional chinese,turkish,ukrainian,vietnamese
-- nls_language     	 true  	 bengali
-- nls_sort         	 false 	 arabic,arabic_abj_match,arabic_abj_sort,arabic_match,ascii7,azerbaijani,bengali,big5,binary,bulgarian,canadian_m,catalan,croatian,czech,czech_punctuation,danish,danish_m,dutch,ebcdic,eec_euro,eec_europa3,estonian,finnish,french,french_m,gbk,generic_baseletter,generic_m,german,german_din,greek,hebrew,hkscs,hungarian,icelandic,indonesian,italian,japanese_m,korean_m,latin,latvian,lithuanian,malay,norwegian,polish,punctuation,romanian,russian,schinese_pinyin_m,schinese_radical_m,schinese_stroke_m,slovak,slovenian,spanish,spanish_m,swedish,swiss,tchinese_radical_m,tchinese_stroke_m,thai_m,turkish,ukrainian,unicode_binary,vietnamese,west_european,xazerbaijani,xcatalan,xcroatian,xczech,xczech_punctuation,xdanish,xdutch,xfrench,xgerman,xgerman_din,xhungarian,xpunctuation,xslovak,xslovenian,xspanish,xswiss,xturkish,xwest_european
-- nls_sort         	 true  	 canadian french,japanese,thai_dictionary,thai_telephone
-- nls_territory    	 false 	 albania,algeria,america,argentina,australia,austria,azerbaijan,bahrain,bangladesh,belarus,belgium,brazil,bulgaria,canada,catalonia,chile,china,colombia,costa rica,croatia,cyprus,czech republic,denmark,djibouti,ecuador,egypt,el salvador,estonia,finland,france,fyr macedonia,germany,greece,guatemala,hong kong,hungary,iceland,india,indonesia,iraq,ireland,israel,italy,japan,jordan,kazakhstan,korea,kuwait,latvia,lebanon,libya,lithuania,luxembourg,malaysia,mauritania,mexico,morocco,new zealand,nicaragua,norway,oman,panama,peru,philippines,poland,portugal,puerto rico,qatar,romania,russia,saudi arabia,serbia and montenegro,singapore,slovakia,slovenia,somalia,south africa,spain,sudan,sweden,switzerland,syria,taiwan,thailand,the netherlands,tunisia,turkey,ukraine,united arab emirates,united kingdom,uzbekistan,venezuela,vietnam,yemen
-- nls_territory    	 true  	 cis,czechoslovakia,macedonia,yugoslavia