Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Friday, 1 April 2016

SQL-Bitand


This will perform bitwise and operation.

     Syntax: bitand (value1, value2)        

     Ex:
          SQL> select bitand(2,3), bitand(0,0), bitand(1,1), bitand(null,null), bitand(-2,-3) from
                   dual;
BITAND(2,3) BITAND(0,0) BITAND(1,1) BITAND(NULL,NULL) BITAND(-2,-3)
--------------  ---------------  --------------   ------------------------  -----------------

          2           0                      1                                                          -4


You May Like                                             
                            SQL Abs
                            SQL Sign
                            SQL Sqrt
                            SQL Mod
                            SQL NVL
                            SQL NVL2
                            SQL Power
                            SQL Exp
                            SQL Ln
                            SQL Log
                            SQL CEIL
                            SQL Floor
                            SQL Round
                            SQL Trunc                           
                            SQL Greatest
                            SQL Least
                            SQL Coalesce
Share this article :

3 comments:

  1. Hi Dayakar,

    In total awe…. So much respect and gratitude to you folks for pulling off such amazing blogs without missing any points on the Oracle Applications Kudos!

    Overloading modules is nothing more than a mechanism that allows the coder to reuse the same name for different programs that are within the same scope. Overloading is probably one of my favourite mechanisms to share and increase usability within code.

    I am facing an issue with DBMS_CHAIN execution.

    Issue: Even one of the step got Failed, remaining steps were processed without waiting for depended step SUCCESS.

    Just FYI: I created 2 chains i.e. Chain1 and Chain2. Calling Chain2 as sub chain in Chain1.

    I attached the total script for your reference and below the run details.

    In the below run_details, you can see STEP2 is in failed state but further steps (i.e. STEP3 of CHAIN1 and STEP1 , STEP2 of CHAIN2 got processed)

    Please suggest me on this(what i need to do to hold at FAILED step and how can I RERUN that FAILED step only (or) from Failed Steps).
    I read multiple articles and watched many videos about how to use this tool - and was still confused! Your instructions were easy to understand and made the process simple.

    Many Thanks,
    Roy

    ReplyDelete
  2. Hi There,

    Jeez oh man,while I applaud for your writing , it’s just so damn straight to the point SQL-Bitand .

    I need help to identify the amount of time spent on a campaign using logon and logoff times. The issue I have is that I can have several logoff times that have the same logon time. I could use the maximum logoff time by campaign but sometimes the campaign will repeat itself in the day. Example of Data is attached.

    I should end up with 4 records.

    LOGON LOGOFF CAMPAIGN
    02/24/2017 8:05:04 AM 02/24/2017 9:00:41 AM CO
    02/24/2017 9:01:22 AM 02/24/2017 10:22:52 AM PR
    02/24/2017 10:37:46 AM 02/24/2017 12:29:44 PM PR
    02/24/2017 3:29:57 PM 02/24/2017 4:00:36 PM CO

    But nice Article Mate! Great Information! Keep up the good work!

    Shukran,
    Preethi.

    ReplyDelete
  3. Greetings Mate,


    This is indeed great! But I think perhaps you are generally referring #topic which is getting unsustainable.


    I need some help from you experts on this stored procedure..

    There are 4-5 batch procedures that will call this stored procedure. The batch will call the stored procedure with 'I' parameter in the beginning of the batch process. The batch will call the stored procedure with 'O' parameter at the end of the batch process. The stored procedure should write the details into the auditing table.






    But great job man, do keep posted with the new updates.

    ReplyDelete