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: Dynamic sql failure

Re: Dynamic sql failure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 31 Jul 2005 12:07:32 +0200
Message-ID: <bl8pe1pqrtlno2v8vdfvml56tbp0ddheeh@4ax.com>


On 31 Jul 2005 02:48:11 -0700, william_hulse_at_hotmail.com wrote:

>table dynamically, then you must also insert into it dynamically, as
>demonstrated below.

Of course this a horrible approach as it will result in hard parses all over the place.
The very reason Oracle invented pl/sql is to get rid of the hard parses.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun Jul 31 2005 - 05:07:32 CDT

Original text of this message

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