rtfm
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, January 25, 2002 10:20 PM
> Hallo all you gurus,
>
> How can I write in the pl/sql code if I want to insert in a table the
number of rows that are inserted in the select statement in t
Jacques are you sure? It would, of course, mean actually READING
the manual
Rachel
--- Jacques Kilchoer <[EMAIL PROTECTED]> wrote:
> 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.
>
> > -Ori
Title: RE: Re: Number_of_rows
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 thatth
Yes But I want thatthat number is inserted into the table.
[EMAIL PROTECTED]@fatcity.com den 2002-01-25 10:39 PST
Sänd svar till [EMAIL PROTECTED]
Sänt av: [EMAIL PROTECTED]
Till: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Kopia:
Use SQL%ROWCOUNT.
BEGIN
insert in
RTFM on SQL%ROWCOUNT and %ROWCOUNT
Jared
Sorry, all exampled out today.
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/25/02 10:20 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Number_o
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.
Raj
[EMAIL PROTECTED]@fatcity.com on 01/25/2002 01:20:40 PM
Please
Hallo all you gurus,
How can I write in the pl/sql code if I want to insert in a table the number of rows
that are inserted in the select statement in the procedure?
Give me a good example, please.
Thanks in advance
Roland S
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-