Re: parameterized views

From: Thomas Kellerer <OSCUQDVXTKFJ_at_spammotel.com>
Date: Tue, 10 Aug 2004 17:24:50 +0200
Message-ID: <2ns7m3F3umsrU2@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 - 10:24:50 CDT