title: Does Oracle DB allows non-stored procedures to be executed?
body: <p>I want a kind of scripting in my app allowing a user to execute arbitrary SQL on my Oracle RBO DB. Not just a select/update but something complicated with loops. But not a stored procedure also (there is no any reason to store such code persistently).</p>
  
  <p>Is there such a thing in Oracle - "non-stored procedure" - and how is it called?</p>