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: equal names of: parameter of procedure - columns of table

Re: equal names of: parameter of procedure - columns of table

From: <andrewst_at_onetel.com>
Date: 23 May 2005 03:52:23 -0700
Message-ID: <1116845543.933459.204360@z14g2000cwz.googlegroups.com>


Werner Hofmann wrote:
> Hallo,
>
> is there an way, to make a difference between the parameter of a
> procedure and the column name of a table if the name is equal?

You can do this:

procedure my proc (age in number) is
begin
  select * from machines m where m.age > myproc.age; ... Received on Mon May 23 2005 - 05:52:23 CDT

Original text of this message

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