Re: Conditional AND, Conditional OR

Of course you can !

But, if have something like that :

select ...
where col1 = '...'
 and (col2 = 'v1' or col2='v2' or col2='v3')

you should better write :

select ...
where col1 = '...'
 and col2 in ('v1', 'v2', 'v3')

Bye.

Pablo Silva a écrit :
>
> Hi!
>
> I get a question about the Boolean Operators...
>
> In Transac SQL (Sybase) it's possible build conditional
> AND's and OR's by means of the use of parentisis, but in oracle
> it is possible to do the same?
>
> Thank's in Advance...
>
> Pablo
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
 

-- 
 Pierre CHARPENAY