Re: use_concat question
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Wed, 8 Jun 2022 08:23:26 +0100
Message-Id: <A48E3D85-7658-4499-BFE6-7458D4D99F3B_at_gmail.com>
Date: Wed, 8 Jun 2022 08:23:26 +0100
Message-Id: <A48E3D85-7658-4499-BFE6-7458D4D99F3B_at_gmail.com>
Which version of Oracle? Do you really mean use_concat rather than or_expand?
It might be safer to do a manual rewrite to Union All with a predicate that blocks accidental duplication
Regards
> On 8 Jun 2022, at 07:21, Laurentiu Oprea <laurentiu.oprea06_at_gmail.com> wrote:
Jonathan Lewis
(From my iPad mini; please excuse typos and auto-correct)
>
> Hello,
>
> For a query which has multiple OR conditions I want to use concatenation for just a particular OR condition and not all of them.
>
> Is this achievable in any way?
>
> Thank you.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 08 2022 - 09:23:26 CEST