Re: parameterized views

From: Ernest Morariu <ernest_at_gesora.com>
Date: Tue, 10 Aug 2004 18:11:41 +0200
Message-ID: <cfas40$k05$1@carabinieri.cs.interbusiness.it>

Thomas,

> Not sure I understand what you mean, but what about this:

No, I didn't intend that. I wanted to say: how can I transmit the <the desired parameter value> to my the view ? See the other posts.

ernest

"Thomas Kellerer" <OSCUQDVXTKFJ_at_spammotel.com> wrote in message news:2ns7m3F3umsrU2_at_uni-berlin.de...
>
> On 10.08.2004 15:39 Ernest Morariu wrote:
>
> > Hi !
> >
> > Is it possible in Oracle to create a parameterized view ?
> >
> > ernest
> >
> >
>
> Not sure I understand what you mean, but what about this:
>
> CREATE VIEW my_view
> (
> column1,
> column2,
> column3,
> parameter_column
> )
> AS
> SELECT col1, col2, col3, col4
> FROM my_table;
>
> Use of paramter:
>
> SELECT column1, column2, column3
> FROM my_view
> WHERE parameter_column = <the desired parameter value>
> ;
Received on Tue Aug 10 2004 - 11:11:41 CDT