title: How to convert a CLOB type column to LONG type column in Oracle DB
body: <p>I need a way to convert a <strong>CLOB</strong> type column to <strong>LONG</strong> type column in Oracle DB without losing data or creating another new table . I am not able to edit types in Oracle SQL Developer
  Is there a way with cursors or something ?
  Please Help
  Thanks </p>