title: how to change the NLS_LANGUAGE and other parameters in oracle
body: <p>i have NLS_LANGUAGE American, I want to change to ITALIAN, The database is oracle 11g.</p>
  
  <p>I am trying the following </p>
  
  <pre><code>ALTER DATABASE CHARACTER SET ITALIAN
  </code></pre>
  
  <p>but this gives error.</p>