| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> Help me with SQL
Peraphs I'm stupid but I don't now how solve following problem....
I'have a table with 2 column, d Date and c VARCHAR2(1);
Can I insert one month in only one SQL instruction or I must use a procedure like this :
d := to_date('01011999', 'mmddyyyy');
for i in 1..31 loop
INSERT INTO table values (d, 'A');
d := d +1;
end loop;
Roby
Roberto.Scanavino_at_rsisistemi.it Received on Wed Jan 20 1999 - 13:55:52 CST
![]() |
![]() |