PL/SQL:Efficiency of inline SQL vs use of Dynamic SQL Package 
Author Message
 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.

Do the SQL inline, then query SQL%ROWCOUNT. See "SQL Cursor" in the PL/SQL
manual.

--




Fri, 02 Mar 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. PL/SQL vs Generic Dynamic SQL packages

2. Advice on Views?: dynamic SQL, using cursors, inline user-defined functions

3. Dynamic SQL Vs Static SQL using Pro*C..

4. SQL-92, Migrate PL/SQL at ORACLE into PL/SQL at SQL Server 7.0

5. 3rd party generated Dynamic SQL vs Packages

6. PL/SQL:Sending Email using PL/SQL

7. Efficiency Question: Stored Proc / Dynamic SQL / Parameter Parsing?

8. Returning a ref cursor with dynamic SQL in PL/SQL

9. pl/sql dynamic sql

10. ampersand problem in dynamic sql and PL/SQL tables

11. FREE Dynamic SQL and PL/SQL Utilities


 
Powered by phpBB® Forum Software