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: parameterized views

Re: parameterized views

From: <bsc7080mqc_at_mylxhq.com>
Date: Wed, 11 Aug 2004 00:19:36 -0400
Message-ID: <jf7jh01dgvhcivrt5c0erspvtemvhgte3q@4ax.com> 





Lots of answers....  but this one wasn't mentioned...



Create your view and then use DBMS_APPLICATION.CLIENT_INFO in the conditions. Set the CLIENT_INFO to your desired value prior to
executing the query. Session independent as well.




On Tue, 10 Aug 2004 15:39:58 +0200, "Ernest Morariu" <ernest_at_gesora.com> wrote:



>Hi !

>

>Is it possible in Oracle to create a parameterized view ?

>

>ernest

>

Received on Tue Aug 10 2004 - 23:19:36 CDT












Original text of this message













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