RE: Re: Number_of

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 25 Jan 2002 17:54:34 -0800
Message-ID: <F001.003FBFC2.20020125174019@fatcity.com>

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: Roland.Skoldblom_at_ica.se [mailto:Roland.Skoldblom_at_ica.se]
>
> Yes But I want thatthat number is inserted into the table.
>
> Rajesh.Rao_at_chase.com_at_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.
Received on Fri Jan 25 2002 - 19:54:34 CST

RE: Re: Number_of_rows