Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL:Efficiency of inline SQL vs use of Dynamic SQL Package
ross_mcadam_at_my-dejanews.com wrote:
: I am writing an application in PL/SQL which involves many SQL insert
: statements where I require a count of the number of records for each insert.
:
Do the SQL inline, then query SQL%ROWCOUNT. See "SQL Cursor" in the PL/SQL manual.
--
Dave Schweisguth Work: davids_at_pangeasystems.com Pangea Systems Home: dschweisguth_at_earthlink.netReceived on Mon Sep 14 1998 - 09:44:02 CDT