Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL:Efficiency of inline SQL vs use of Dynamic SQL Package
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.
My query is whether 1. It is more efficient to perform SQL inline and use select count(*) to return the number of rows;, or, 2. Use the dynamic SQL package which also returns the number of rows inserted.
Thanks in advance, RM.
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 14 1998 - 04:11:43 CDT