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: Werner Hofmann <superomega_at_t-online.de>
Date: Tue, 24 May 2005 09:37:11 +0200
Message-ID: <d6ulk5$h37$1@svr7.m-online.net>


andrewst_at_onetel.com wrote:
> 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;
> ...
>

Thank you it's working Received on Tue May 24 2005 - 02:37:11 CDT

Original text of this message

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