title: How to change column data type to DOUBLE in SQL?
body: <p>I want to change the data type of an existing column of a particular table using below statement:</p>
  
  <pre><code>ALTER TABLE tablename MODIFY columnname DOUBLE; 
  </code></pre>
  
  <p>but it throws following <strong>error</strong>, </p>
  
  <blockquote>
    <p>SQL Error: ORA-00905: missing keyword 00905. 00000 - "missing keyword"
    *Cause: *Action:</p>
  </blockquote>
  
  <p>Can anyone help to avoid this error or else help to find the root cause of this error? Thank you</p>