insert a sequence into a table

hi there
I have a table as
CREATE TABLE tname(sn number(3));
and then I want to insert value from 1 to 500. I created a sequence sq and I can do this: INSERT INTO tname VALUES(sq.nextval);
the problem is how can I use WHERE clause to control the number of rows to be inserted? Regards
Charles Luo Received on Mon Jun 28 1999 - 19:22:11 CDT