Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: FOR crs IN ( .... ) LOOP with dynamic SQL
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 DBAReceived on Thu Jan 19 2006 - 08:23:00 CST