title: Sql query with bind variables execution in Jdbc
body: <p>I have a sql query like this.</p>
  
  <pre><code> select "DEPT"."DEPTNO" as "DEPTNO1",
  "DEPT"."DNAME" as "DNAME1",
  "DEPT"."LOC" as "LOC1",
  "EMP"."COMM" as "COMM1",
  "EMP"."EMPNO" as "EMPNO1",
  "EMP"."ENAME" as "ENAME1",
  "EMP"."HIREDATE" as "HIREDATE1",
  "EMP"."JOB" as "JOB1",
  "EMP"."MGR" as "MGR1",
  "EMP"."SAL" as "SAL1"
  from "EMP" , "DEPT" where "DEPT"."DEPTNO" in (:DeptNo)
  </code></pre>
  
  <p>//This is the Jdbc code</p>
  
  <pre><code>Class.forName(DB_DRIVER);
  dbConnection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);
  Statement statment = dbConnection.createStatement();
  result = statment.execute(query);//query is above sql query
  </code></pre>
  
  <p>When i run above query in Oracle sql developer works perfectly.But when i run it with above jdbc code it is throwing Not all variables bound exception.
  How to run above query in JDBC</p>