help me in getting the meaning of oracle or jsp statemnt

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 28 Mar 2003 13:06:37 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7037C67BC@lnewton.leeds.lfs.co.uk>

And so, it is really crying out for a bind variable :o)

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: mvk_at_servocomp.ru (Michael Kuznetsov) [mailto:mvk_at_servocomp.ru] Posted At: Friday, March 28, 2003 12:48 PM Posted To: server
Conversation: help me in getting the meaning of oracle or jsp statemnt Subject: Re: help me in getting the meaning of oracle or jsp statemnt

Hi kasi,

It's simple. + is string concatenation operator in Java.

String ecode = "1234";
rs2=st2.executeQuery("select name from emp where ecode='"+ecode+"'");

Oracle Database will recive this SQL operator:  

select name from emp where ecode='1234'

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com Received on Fri Mar 28 2003 - 07:06:37 CST