title: Bind variables in SQL Developer - data type
body: <p>I'm trying to use bind variables in SQL Developer. The problem is that I can't set the variable to type <code>NUMBER</code> - it's type is always set to <code>VARCHAR2(32)</code>:</p>
  
  <pre><code>create view test1v as select 1 as abc from dual;
  VARIABLE X NUMBER;
  EXEC :X := 1;
  explain plan for SELECT /*TOTO7*/ * FROM test1v where rownum = :X;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/H9tbO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/H9tbO.png" alt="enter image description here"></a></p>
  
  <p>I'm using SQL Developer 17.4.0.355</p>