title: ORA-01735: invalid ALTER TABLE option (While trying to drop DEFAULT on a COLUMN)
body: <p>I was trying to drop DEFAULT constraint on COLUMN sal i.e. salary in customer table in Oracle Database.</p>
  
  <p>SQL statement which I tried was</p>
  
  <pre><code>ALTER TABLE customer ALTER COLUMN sal DROP DEFAULT;
  </code></pre>
  
  <p>Error message which I received was</p>
  
  <pre><code>ALTER TABLE customer ALTER COLUMN sal DROP DEFAULT
  Error report -
  SQL Error: ORA-01735: invalid ALTER TABLE option
  01735. 00000 -  "invalid ALTER TABLE option"
  *Cause:    
  *Action:
  </code></pre>
  
  <p>Can anyone tell me the mistake which I am doing?</p>