Re: View with parameters ?

From: Vincent FABRI <Vincent.Fabri_at_mail.dotcom.fr>
Date: 2000/07/05
Message-ID: <8k07s3$fbd$1@wanadoo.fr>#1/1

Walter T Rejuney <BlueSax_at_Unforgetable.com> a écrit dans le message : 39637BC1.FC49D6F1_at_Unforgetable.com...
> Vincent FABRI wrote:
> >
> > Hi,
> > Is possible create view with parameters ?
> > If so, where can i find sample and syntax ?
> > Thank.
> > -------------------------------------------------------------------
> > http://hydravions.decollage.org
> > -------------------------------------------------------------------
>
> What do you mean "with parameters"? What are you trying to do?
Like ACCESS Qyery

PARAMETERS p1 Text, p2 Short;
SELECT CTA_NUM, ACT_OBS
FROM Activite
WHERE CTA_NUM=[p1] AND ACT_OBS=[p2];

I would like translate this query for oracle....

---

Vincent FABRI
http://hydravions.decollage.org

---

Received on Wed Jul 05 2000 - 00:00:00 CDT