Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- A,
- LENGTH(A) LENGTH_A,
- B,
- LENGTH(B) LENGTH_B,
- UTL_RAW.BIT_AND(TRIM(A),TRIM(B)) AND_AB,
- LENGTH(UTL_RAW.BIT_AND(TRIM(A), TRIM(B))) LENGTH_AND_AB FROM (
- SELECT
- TRIM(RPAD('0', LENGTH('1111111111111100000000000000011') - 30 ,'0')) || '1' ||TRIM(RPAD('0', 29, '0')) A,
- '1111111111111100000000000000011' B FROM DUAL);
- A LENGTH_A B LENGTH_B AND_AB LENGTH_AND_B
- 0100000000000000000000000000000 31 1111111111111100000000000000011 31 00100000000000000000000000000000 32
Add Comment
Please, Sign In to add comment