Re: tuning query with concat string.
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx
- Date: Tue, 21 Mar 2006 07:31:42 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
