title: Alternatives for Continuous Query Notifications in Oracle 12c CDB/PDB setup
body: <p>Long time trawler and massive fan of the site (you guys effectively taught me to code so big props to you all :D).</p>
  
  <p>So as for my first question:</p>
  
  <p>My company is currently developing an application that is back ended by an Oracle database, now in production this is going to be deployed in a 12c multi-tenant architecture. However the issue is our offshore development house had been developing and testing on 11g and incorrect infrastructure, something I have pushed to and mostly fixed since joining the compnay some months ago. </p>
  
  <p>We have now hit a stumbling block, it has become apparent that our development house have no actual Oracle expertise and are SQL Server developers playing at Oracle, as such they are stuck on how to implement the functionality of <strong>Continuous Query Notification (CQN)</strong> in Oracle 12c given that this is deprecated in multi-tenant architecture.</p>
  
  <p>I want to ask if anyone here has any suggestions for way to achieve the same functionality of a CQN in Oracle 12c?</p>
  
  <p>The use of external scripts or solutions is doable, basically no limit on suggestions as we are at a stage where could potentially factor in any possible resolution.</p>
  
  <p>Any help greatly appreciated.</p>