Oracle Error ORA-12994: drop column option only allowed once in statement

Oracle Error Message

ORA-12994: drop column option only allowed once in statement

Reason for the Error

An attempt was made to repeat the drop column option in a single statement.

Solution

Separate drop column options into different statements and resubmit statements.