Oracle数据删除列，能不能用select语句的结果

alter table TESTTABLE drop(SELECT COLUMN_NAME FROM USER_TAB_COLUM .........)
能不能这样写？

ALTER TABLE 表名 DROP COLUMN 字段名

 delete  from testtable t where exists(select 1 from user_tab_colum utc where t.column_name=utc.column_name)