daily pastebin goal
3%
SHARE
TWEET

Untitled

a guest Dec 11th, 2018 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2. A,
  3. LENGTH(A) LENGTH_A,
  4. B,
  5. LENGTH(B) LENGTH_B,
  6. UTL_RAW.BIT_AND(TRIM(A),TRIM(B)) AND_AB,
  7. LENGTH(UTL_RAW.BIT_AND(TRIM(A), TRIM(B))) LENGTH_AND_AB FROM (
  8. SELECT
  9.     TRIM(RPAD('0', LENGTH('1111111111111100000000000000011') - 30    ,'0')) || '1' ||TRIM(RPAD('0', 29, '0')) A,  
  10. '1111111111111100000000000000011' B FROM DUAL);
  11.    
  12. A                                 LENGTH_A  B                               LENGTH_B  AND_AB                           LENGTH_AND_B
  13. 0100000000000000000000000000000   31        1111111111111100000000000000011 31        00100000000000000000000000000000 32
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top