pl/sql forcing RHS of = in where clause to be variable?

#21

Maxim Demenko <mdemenko (AT) gmail (DOT) com> wrote:

Quote:

4 select ename into l_ename from emp where empno = abc.empno;

Ah, this is just what I was hoping for.
Thank you so much Maxim!

--
Mark Harrison
Pixar Animation Studios

#22

mh (AT) pixar (DOT) com schrieb:

Quote:

Maxim Demenko <mdemenko (AT) gmail (DOT) com> wrote:
4 select ename into l_ename from emp where empno = abc.empno;

Ah, this is just what I was hoping for.
Thank you so much Maxim!

You are welcome, just for the record, all that can be found at usual
place ;-)

http://download.oracle.com/docs/cd/B....htm#sthref431

Best regards

Maxim

#23

mh (AT) pixar (DOT) com schrieb:

Quote:

Maxim Demenko <mdemenko (AT) gmail (DOT) com> wrote:
4 select ename into l_ename from emp where empno = abc.empno;

Ah, this is just what I was hoping for.
Thank you so much Maxim!

You are welcome, just for the record, all that can be found at usual
place ;-)

http://download.oracle.com/docs/cd/B....htm#sthref431

Best regards

Maxim

#24

mh (AT) pixar (DOT) com schrieb:

Quote:

Maxim Demenko <mdemenko (AT) gmail (DOT) com> wrote:
4 select ename into l_ename from emp where empno = abc.empno;

Ah, this is just what I was hoping for.
Thank you so much Maxim!

You are welcome, just for the record, all that can be found at usual
place ;-)

http://download.oracle.com/docs/cd/B....htm#sthref431

Best regards

Maxim

#25

mh (AT) pixar (DOT) com schrieb:

Quote:

Maxim Demenko <mdemenko (AT) gmail (DOT) com> wrote:
4 select ename into l_ename from emp where empno = abc.empno;

Ah, this is just what I was hoping for.
Thank you so much Maxim!

You are welcome, just for the record, all that can be found at usual
place ;-)

http://download.oracle.com/docs/cd/B....htm#sthref431

Best regards

Maxim

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

pl/sql forcing RHS of = in where clause to be variable?

comp.databases.oracle.misc comp.databases.oracle.misc

Re: pl/sql forcing RHS of = in where clause to be variable? - 07-01-2008 , 05:38 PM

Re: pl/sql forcing RHS of = in where clause to be variable? - 07-01-2008 , 05:40 PM

Re: pl/sql forcing RHS of = in where clause to be variable? - 07-01-2008 , 05:40 PM

Re: pl/sql forcing RHS of = in where clause to be variable? - 07-01-2008 , 05:40 PM

Re: pl/sql forcing RHS of = in where clause to be variable? - 07-01-2008 , 05:40 PM