title: Using batch file to create new table in oracle/sqlplus
body: <p>I want create new table in <code>oracle</code> with <code>sqlplus</code> and <code>batch</code> file.</p>
  
  <pre><code>sqlplus user/password @create_tables.sql
  </code></pre>
  
  <p>it is successfully</p>
  
  <p>but that's not what I want. I want the user to input year.
  My batch file look like :</p>
  
  <pre><code>@echo off
  
  set /p year=__YEAR (YYYY)?
  sqlplus user/password
  create table data%year%
  (Nama varchar2(25),
  value number);
  echo Successfull
  pause
  </code></pre>
  
  <p>script stops here</p>
  
  <pre><code>SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 25 06:07:26 2013
  
  Copyright (c) 1982, 2005, Oracle.  All rights reserved.
  
  
  Connected to:
  Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
  With the Partitioning, OLAP and Data Mining options
  
  SQL&gt;
  </code></pre>
  
  <p>what's wrong?</p>