tuning query with concat string.

From: The Human Fly <sjaffarhussain_at_gmail.com>
Date: Tue, 21 Mar 2006 18:10:13 +0300
Message-ID: <97b7fd2f0603210710y4db4ee1ahdbd87cf94768a5cf@mail.gmail.com>

Hello list,

How can I rewrite the query which uses concatination in the where clause? For an example,

SELECT ...... FROM where COLUMN = 'S'||'VALUE2';

Thanks for your time.

--

Best Regards,
Syed Jaffar Hussain
8i,9i & 10g, OCP DBA
Banque Saudi Fransi,
Saudi Arabia
http://jaffardba.blogspot.com/

---

"Winners don't do different things. They do things differently."
--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 21 2006 - 09:10:13 CST