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

Thread: bit to bit query ?

  1. #1
    Join Date
    Sep 2002
    Posts
    1
    Hello,
    i would like to execute bit to bit query like this with sqlserver :

    SELECT a_int_value ^ b_int_value
    FROM bitwise

    How can i do with oracle ?
    ^ and | operators does not exist..

    thanks

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Oracle has operation that can work with bit (RAW) variables.
    U should convert ur source variable into RAW datatype and than u may use
    bit operations.

    See:
    http://download-east.oracle.com/otnd...raw.htm#998101

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    For a bitwise AND operation Oracle has a built-in function BITAND(), it has been available since ancient history but it hasn't been documented until 8i. It is used extensively inside oracle's datadictionary views.

    For any other types of bitwise operations you'll have to use UTL_RAW package like Shestakov suggested.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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