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: Parameter to an oracle view

Re: Parameter to an oracle view

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 16 Jan 2002 14:16:19 GMT
Message-ID: <TWf18.749$q42.553@rwcrnsc54>


Either by
select ... from myview where your where condition or write a stored procedure that returns a ref cursor. The in parameter could be the parameter for the where clause. A view is treated just like a table for all intents.
Jim
"Florian May" <Florian.May_at_mysoftware.de> wrote in message news:a23mau$68n$03$1_at_news.t-online.com...
> Hi,
>
> kann ich - beispielsweise von einem Front-End aus - an einen Oracle-view
> einen Parameter senden, auf den dann im where-statement zugegriffen wird?
>
> Gruß
>
>
> Florian
>
> can I - for example from any front-end - send a parameter to an oracle
view,
> and this parameter will processed in the where-statement of the view?
>
>
> Regards
>
>
> Florian
>
>
Received on Wed Jan 16 2002 - 08:16:19 CST

Original text of this message

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