title: Can I declare local temporary table in Oracle 12c
body: <p>I'm trying to declare local temporary table using the example from <a href="https://www.techonthenet.com/oracle/tables/local_temp.php" rel="nofollow noreferrer">Oracle / PLSQL: LOCAL TEMPORARY TABLES</a>. But when I try to insert it into <code>sqlplus' CLI</code> and hit <kbd>Enter</kbd>, it does not execute anything and I don't know what to do next to complete the command except pressing <kbd>Ctrl</kbd>+<kbd>C</kbd> interrupting command inputing:</p>
  
  <pre><code>SQL&gt; DECLARE LOCAL TEMPORARY TABLE suppliers_temp
  ( supplier_id number(10) NOT NULL,
    supplier_name varchar2(50) NOT NULL,
    contact_name varchar2(50)
  );  2    3    4    5
    6
    7  ;
    8  ^C
  </code></pre>
  
  <p>To execute this query I've logged in as <strong>SYSTEM</strong> user.</p>
  
  <p>Why this example does not work for me?</p>