Thread: Data Gathering

hello everyone there!

i need ur help for extracting data for complete month.
supposingly i have maintained data on daily basis like feb01,feb02...............feb29. but now i want to join the data for the whole month i.e. complete feb. Is there any way out of how can i do such a thing. plz its very urgent.

thanking in anticipation,
Reet

create a table 'feb' for storing february month data

declare
str varchar2(3);
begin
str:='FEB';
for i in 1..29
LOOP
IF I <10 THEN
Execute immediate 'insert into FEB select * from '||STR||0||I;
ELSIF I>=10 THEN
Execute immediate 'insert into FEB select * from '||STR||I;
END IF;
END LOOP;
END;

Its a very good attemp. I hav also got the solution but longer in the lines. But after having a look on your script, its really impressive.

Hi susarlasireesha,

Thanks for your solution.