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

Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamic Search Conditions using PL SQL

Re: Dynamic Search Conditions using PL SQL

From: <sybrandb_at_hccnet.nl>
Date: Wed, 13 Jun 2007 00:52:05 +0200
Message-ID: <9q8u63pqpjncqe4o7lmqjkfqqvfiaba5jf@4ax.com>


On Tue, 12 Jun 2007 19:37:47 -0000, Valentin Minzatu <valentinminzatu_at_yahoo.com> wrote:

>I never did an impact analysis between implementing dynamic SQL and
>VPD and I do not know neither the business case nor the usage/size/etc
>of the database hence the question (as opposed to affirmation), but
>from the example it looks like it may be the case for it or for
>implementing something along those lines.

VPD is always in use, even during export. It is only disabled when SYS exports the database.
Still think this is a viable suggestion to avoid dynamic sql?

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jun 12 2007 - 17:52:05 CDT

Original text of this message

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