Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: equal names of: parameter of procedure - columns of table
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
![]() |
![]() |