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: Parameters in query

Re: Parameters in query

From: <bjorn_at_sb.artech.se>
Date: Fri, 23 Apr 1999 15:54:18 GMT
Message-ID: <7fq537$21i$1@nnrp1.dejanews.com>


In article <bwpR2.360$2B1.3284_at_news1.online.no>,   "Arild Kvalbein" <arkvalbe_at_online.no> wrote:
> Hi,
>
> I know this must be a newbie question, but I'm only using Oracle (UNIX) for
> a school project...
> How do I create a parameterized query/view in Oracle?
> In MS Access I would f.ex write SELECT * FrOM Table WHERE Name=[Your
> Name:];, which would open ea requester asking "Your Name:" when the query is
> run.
> Is there any way to do this in Oracle?
>
> ---
> Arild Kvalbein
> <arkvalbe_at_online.no>
> <arild_at_c-map.no>
>
> The simplest way to do this i to type & before the parameter.
SELECT * FrOM Table WHERE Name='&Your_name';

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Apr 23 1999 - 10:54:18 CDT

Original text of this message

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