Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: opinion solicited
In article <2dete0ploue440mleko24bd1cc6skaqf38_at_4ax.com>,
nospam_at_noway.nohow says...
> >"Ed Stevens" <nospam_at_noway.nohow> wrote in message
> >news:me3te0h1o11p1m7pmqarlv0kk6a45j841v_at_4ax.com...
> >
> True enough, but also makes statements like this:
>
> "Taking PL/SQL first of all, the good news is that PL/SQL itself takes
> care of most of the issues to do with bind variables, to the point
> where most code that you write already uses bind variables without you
> knowing. "
>
He's right. In PL/SQL, if you write
SELECT lastname INTO v_lastname FROM customers WHERE custid = p_custid;
This almost looks like a concatenated string in any other language. But it's not, it's using a bind variable (without most people knowing). Probably this is what he meant.