Hi,

I have a table in which I want to input.

I have a table:

desc Calender
Name Null? Type
----------------------------------------- -------- ----------------------------
DATE DATE
JOB_SEq NUMBER(10)

The data in the DATE column is the same as below
05-JAN-03
06-JAN-03

The problem is I want to insert data for the whole of 2003, My question is, is there a simple pl/sql loop I can write without having to write numerous insert statements to get data ranging from
05-JAn-03 - 31-DEc-03.


Thanks in advance...