Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: FOR crs IN ( .... ) LOOP with dynamic SQL

Re: FOR crs IN ( .... ) LOOP with dynamic SQL

From: <sybrandb_at_yahoo.com>
Date: 19 Jan 2006 06:23:00 -0800
Message-ID: <1137680579.970401.280860@g43g2000cwa.googlegroups.com>


Not sure why you want to replace static sql by dynamic sql. As you know dynamic sql means: parse once , execute once. The number 1 recipe to serialize your sql and create unscalable applications.
If you insist on dynamic sql, look up Native Dynamic SQL or REF CURSOR in the pl/sql documentation, or even the dbms_sql package.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Thu Jan 19 2006 - 08:23:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US