Re: tuning query with concat string.

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

:-)

Quoting The Human Fly <sjaffarhussain_at_gmail.com>:

> 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