Hi
I'm running into the pattern-length limitation for REGEXP_LIKE. It's 512 bytes (ie 512 chars at 1 byte/char ascii).
https://docs.oracle.com/cd/B19306_01/server.102/b14200/conditions007.htm
I notice that our data contains a reduced data-set-- we don't need all 256 chars in the ascii char set.
ASCII and Binary Characters (The Characters)
Question:
Is there a SQL function which can reduce the bit-size of the characters in a string?
We only need the first 6 or 7 bits.
I don't see any fx that could do this, but a more expert dev might know
https://docs.oracle.com/cd/E57340_01/DR/Bit_Binary_Functions.html
Question:
Or, is there a way to reduce the character-set of a string, in order to accomplish the same goal?
if these ideas can't work, then i'll just split my REGEXP_LIKE into 2 conditionals -
WHERE REGEXP_LIKE(etc) OR REGEXP_LIKE(etc)
thx!