need to insert 365 days in a table
AnsafFeb 19 2009 — edited Feb 19 2009
I am using oracle 10g.
now i displayed the 365 days using the query below
select trunc(sysdate,'YEAR')+rownum -1 dates
from dual
connect by rownum < 366;
now i need to insert 365 days in a into a table called DAYS_IN_A_YEAR.
table structure is:
CREATE TABLE DAYS_IN_A_YEAR (
DATE_COLUMN DATE)
Regards,
Ansaf.