title: Change to other database in sql developer
body: <p>I would like to change the database connection of a SQL worksheet in Sql Developer. For example I'm now working in database connection !OMY_OWNER_C_1 and want to change the database connection to !OMY_OWNER_C_2.</p>
  
  <p>The way I do that now is by clicking on the 'Choose DB connection' button on the top right, and select !OMY_OWNER_C_2, but I want to achieve the same by running some sql.</p>
  
  <p>Can anyone tell me how to that that? (or whether it is possible?)</p>
  
  <p>I already tried some with 'ALTER SESSION SET current_schema = !OMY_OWNER_C_2;', but that does not do the trick. </p>
  
  <p>In other stack overflow threads a simular question is there, and the use of 'ALTER SESSION SET current_schema = !OMY_OWNER_C_2' is suggested, but for me that does not do the trick. I do something wrong or it just can't, or there is something else why it does not work.</p>
  
  <p>In Sql Server I just use 'USE database !OMY_OWNER_C_2', but Oracle/Sql developer works different.</p>
  
  <p>I made two printscreens which makes some above used names more clear hopefully: <a href="http://prntscr.com/9mo3us" rel="nofollow">http://prntscr.com/9mo3us</a> and <a href="http://prntscr.com/9mo7hh" rel="nofollow">http://prntscr.com/9mo7hh</a>.</p>