I am altering constraints during my database and I have to drop a number of them. I understand that for any single constraint, the command is following:

ALTER TABLE tblApplication DROP CONSTRAINT constraint1_name;

However, after i try

ALTER TABLE tblApplication DROP (
  CONSTRAINT constraint1_name,
  CONSTRAINT constraint2_name
);

it does not work and I have to do:

ALTER TABLE tblApplication DROP CONSTRAINT constraint1_name;
ALTER TABLE tblApplication DROP CONSTRAINT constraint2_name;

It is possible to method to remove several constraint in one command? Let me avoid repeating ALTER TABLE tblApplication, much like using the ADD command:

ALTER TABLE tblApplication 
  ADD {
    CONSTRAINT contraint1_name FOREIGN KEY ... ENABLE,
    CONSTRAINT contraint2_name FOREIGN KEY ... ENABLE,
};

You actually can. You need to simply repeat 'drop constraint' per constraint. e.g.

alter table t1
drop constraint fk1
drop constraint fk2
/

Edit: I examined this against Oracle 11, also it labored fine. Haven’t heard of older versions.