In list vs OR
Hi,
Anyone can help point to Oracle docs where it describes how the parse parses in list predicates?
For example
Does Oracle translates
where column_name in ('A','B')
into
where column_name = 'A' or column_name = 'B' ?
So in terms of parsing there is no benefit of using in ('A','B') other than in list is easy to code?
Thanks,
Sha
For example
Does Oracle translates
where column_name in ('A','B')
into
where column_name = 'A' or column_name = 'B' ?
So in terms of parsing there is no benefit of using in ('A','B') other than in list is easy to code?
Thanks,
Sha
0