Re: tuning query with concat string.

SELECT ...... FROM where COLUMN = 'SVALUE2';

:-)

Quoting The Human Fly <sjaffarhussain@xxxxxxxxx>:

> How can I rewrite the query which uses concatination in the where
> clause? For an example,
> 
> SELECT ...... FROM where COLUMN = 'S'||'VALUE2';
> 
-- 
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

--
http://www.freelists.org/webpage/oracle-l


Other related posts: