Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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.

This post has been answered by 548091 on Feb 19 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2009
Added on Feb 19 2009
15 comments
2,132 views