Alter table to add and modify columns
636380Jun 17 2009 — edited Jun 17 2009hi All,
i have 200 tables in a schema with suffix '_0'
i want to modify all the columns of these tables to varchar2(4000).
and add 2 new columns date1 and date 2
what is the best way to do this.
please advice.