Oracle Solution for Error ora-12994

Solution for Oracle Error ORA-12994

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

What triggered the Error:

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

What should we do to fix it:

Separate drop column options into different statements and resubmit statements.