I have 10 tables named mytable_1,mytable_2,mytable_3
and so on
with similar schemas..I want to insert similar data into these 10 tables..
insert into mytable_1
select * from urtable...instead of using the insert statement
10 times, is there is way i can insert the data into
all 10 tables in single query ?