Oracle

select userenv('language') from dual;

MySQL

SHOW VARIABLES LIKE 'character_set_database';