Re: Number_of_rows
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 the procedure? Give me a good example, please. Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam Roberts INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Number_of_rows
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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Number_of_rows
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 respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: 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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Number_of_rows
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_of_rows 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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ang: Re: Number_of_rows
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 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 respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: 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 -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re: Number_of_rows
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 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.
RE: Re: Number_of_rows
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. -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. __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).