Could you please help me in this, In a script if I want to do following

I have two set of tables.

Table_T1

Table_T2_1, Table_T2_2, Table_T2_4, Table_T2_5,Table_T2_6

Each table in table set Table_T2_* contain data for one month only whereas table table_T1 contain data for multiple months.

I want to select Year & month from each of Table_T2_* & check if any record for that year month in Table T1

If yes then Insert those record in that table by load from cursor into respective table Table_T2_* . I want to do that in loop.

Ex:-

Suppose Table_T2_1 contain data for May-2005 so I need to load all May 2005 data from table Table_T1 to Table_T2_1, similarly if Table_T2_2 contain data for Nov-2005 then pick all records for Nov_2005 from Table_T1 & insert in Table_T2_2.

Thanks in advance

This forum is for "Unix Shell Scripts"
I suggest you post this question in the relevant database forum