I'm on an Oracle 12c database; I have a column of data with values resembling this: HL7_Result_for_Message_ID_123Q324343.hl7 I need to grab that ID number (in bold), the challenge being that it ...

I am not getting any oracle errors, just the padding on the right that wont go away. I have tried the sub select and got the same result. I will try substr and get back to you.

Contribute to rana403/ORACLE_ALL_QUERY development by creating an account on GitHub. Skip to content. Navigation Menu Toggle navigation. Sign in Product GitHub Copilot. Write better code with AI ...