Guest User

Untitled

a guest
Dec 11th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  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
Add Comment
Please, Sign In to add comment