Retrieve and set Oracle Charset

Retrieving

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;


Settiing

ALTER DATABASE CHARACTER SET WE8ISO8859P1;


Usefull in exp imp command beetwen differente oracle databases with different charset.