DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: & and Or operator question

  1. #1
    Join Date
    Sep 2000
    Posts
    103
    Sorry if this is posted in the wrong forum.
    Can someone tell me how oracle works for this

    I've got a where clause which says
    A & B OR C

    There are no brackets involved so how does oracle deal with this

    Will the solution be
    1) (A & B) OR C

    2) A & ( B OR C).


    Thanks for the help.

  2. #2
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Evaluation Order (Highest precedence top down)

    **, NOT Exponentiation, local negation

    +, - Identify sign

    *, / Multiplication, division

    +, -, || Addition, subtraction, concatenation

    =, !=, <<, >>, <=, >=, IS NULL, LIKE, BETWEEN, IN Comparison

    AND Conjunction

    OR Inclusion

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width