tuning query with concat string.
- From: "The Human Fly" <sjaffarhussain@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Mar 2006 18:10:13 +0300
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."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
