Re: insert a sequence into a table

I posted a solution to this type of problem on my website a couple of days ago
(under the heading: Dummy Data).

Appropriate for 8 with the object option No sequence needed, you could even
do the

    create table
    unrecoverable
    as

        ....

and create it with the data in place.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

CL wrote in message ...
>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 Wed Jun 30 1999 - 05:45:50 CDT