SQL & PL/SQL

Hi,

I would like to drop all constraints from a table.

So, instead of

delete from user_constraints
where CONSTRAINT_NAME in (select CONSTRAINT_NAME from user_constraints where table_name ='Table_Name') ;

i would like to use alter table for dropping the contraints

alter table table_name
drop constraints in
(select CONSTRAINT_NAME from user_constraints where table_name ='table_name') ;

Can someone let me know of correct query to do this.

Thanks,
Vidya