Hi,
I have a query in Postgres which uses a set_bit function. I need to convert this query into Oracle. However, I cannot find the function which does the exact same thing. Can someone please give me a pointer? Can I use combination of different functions in Oracle to achieve the same thing? Can someone give me a suggestion? Thank you!
Below is the definition of what set_bit does in Postgres:
Function | Return Type | Description | Example | Result |
set_bit(string, offset,newvalue) | bytea | Set bit in string | set_bit(E'Th\\000omas'::bytea, 45, 0) | Th\000omAs |