title: How to make df.to_sql() create varchar2 object
body: <p>I have a <code>DataFrame</code> which consists of a column of strings. If I do <code>df.to_sql()</code> to save it as a table into an Oracle database, the column is of CLOB type and I need to convert it. I wonder if I can specify the type (say <code>varchar2</code>) when I create the table?</p>