Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: opinion solicited

Re: opinion solicited

From: tojo <Tojo_at_hotmail.com>
Date: Fri, 9 Jul 2004 18:13:49 +0200
Message-ID: <MPG.1b58e2a6e817d83a9896f5@news.t-online.de>


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.

Received on Fri Jul 09 2004 - 11:13:49 CDT

Original text of this message

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