Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Help me with SQL

Help me with SQL

From: Scanavino Roberto <roberto.scanavino_at_rsisistemi.it>
Date: 20 Jan 1999 19:55:52 GMT
Message-ID: <01be44b0$29d4d720$38cab9c2@drake>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US