Dit script haalt de characterset van de database op

set heading off
set pagesize 0
set feedback off
set verify off
set echo off
select 'export NLS_LANG='||a.value || '_' ||
b.value || '.' ||
c.value
from nls_database_parameters a,
nls_database_parameters b,
nls_database_parameters c
where a.parameter = 'NLS_LANGUAGE'
and b.parameter = 'NLS_TERRITORY'
and c.parameter = 'NLS_CHARACTERSET'
/