title: Oracle (PL/SQL) : Temporarily change character set
body: <p>I have a csv file and two database (let's call them A and B). My goal is to insert data from csv file into the database B. However, I have to work in the environment of the database A.</p>
  
  <p>The problem is that the character set of the database A makes me lose information (such as accents, I work with czech words). And the icing on the cake, I do not have the rights to change it. N character set doesn't help me further.</p>
  
  <p>So, can I change the character set for just a pl / sql script?</p>
  
  <p><strong>Database A</strong>:</p>
  
  <p>NLS_CHARACTERSET = WE8MSWIN1252</p>
  
  <p>NLS_NCHAR_CHARACTERSET = AL16UTF16</p>
  
  <p><strong>Database B</strong>:</p>
  
  <p>NLS_CHARACTERSET = UTF8</p>
  
  <p>NLS_NCHAR_CHARACTERSET = UTF8</p>