| print calendar [message #272021] |
Wed, 03 October 2007 12:16  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hi All,
I would like to have a Pl/Sql code wherein I can have the total year in the format of calendar i.e right from the week number,day and the date.
like
WeekNo. Day Date
------------------------
1 Sun 01-Jan-2007
till
52 Sat 31-Dec-2007.
I've searched using the string calendar , but that is in SQL.
Looking forward for your help.
Regards,
Raj
|
|
|
|
|
|
| Re: print calendar [message #272025 is a reply to message #272021] |
Wed, 03 October 2007 12:30  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hi Michel,
Before posting I searched with the string "Calendar" , but I could'nt find the one same one as I'm looking in Pl/sql Using loops.
I'm able to get the days of the week but not the calendar:
declare
i number:=1;
begin
while(i<8)
loop
select to_char(next_day(sysdate,i),'day') from dual;
dbms_output.put_line(i);
i:=i+1;
end loop;
end;
So, plz help by giving me a query for calendar using pl/sql like
in the format of calendar i.e right from the week number,day and the date .
WeekNo. Day Date
------------------------
1 Sun 01-Jan-2007
till
52 Sat 31-Dec-2007.
Looking forward for your help.
Regards,
Raj
i.e.,
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
