Oracle SQL has a handy-dandy command called INSERT that allows you to put data into a table. I think INSERT is documented in the SQL manual.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> Yes But I want thatthat number is inserted into the table.
>
> [EMAIL PROTECTED]@fatcity.com den 2002-01-25 10:39 PST
>
> Use SQL%ROWCOUNT.
>
> BEGIN
> insert into table1
> select * from table2;
> dbms_output.put_line(SQL%ROWCOUNT);
> END;
> /
>
> Executing this PL/SQL block should display you the number of
> rows that were
> inserted into table1.
