-
Junior Member
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
-
Expert Member
Re: Data Gathering
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;
-
Junior Member
Re: Data Gathering
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.
-
Junior Member
Re: Data Gathering
Hi susarlasireesha,
Thanks for your solution.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules