I'm writing a pl/sql program to insert the month number and number of days in that month into a table called Month_Days. I only want to use the Insert Into command once, and I also don't want to use a nested If statement. i can get the month number into month column using a loop and a counter going up to 13, but i don't know how to get the number of days into the days column. I'm assuming Jan has 31 days, Feb has 29, March has 31, Apr has 30, etc.
Here's what i have so far:
Create Table Month_Days(
If LoopX=13 Then
Insert Into Month_Days Values (LoopX);
Try this.... change the year or use current year in the TO_DATE line, it will also give 29 days for a leap year if required.
for nMonth in 1..12 loop
nDays := TO_CHAR(LAST_DAY(TO_DATE('01/'||nMonth||'/2002','DD/MM/YYYY')),'DD');
dbms_output.put_line('Month '||nMonth||' days '||nDays);