Hello,
Greetings, my version of Oracle is Oracle Database 19c 19.0.0.0.0.0.
I have a text (PURCHASEORDER988-01) and I need to remove the text and have the following result (988-01) when I run it.
This would be the example:
---------------------
| NUMBER |
---------------------
|PURCHASEORDER988-01|
---------------------
|PURCHASEORDER100-10|
---------------------
But the result I need, as you can see, is as follows:
---------------------
| NUMBER |
---------------------
|988-01 |
---------------------
|100-10 |
---------------------
Then I don't know if you know of any function that separates the text from the numbers, I hope you can help me.
Thank you very much.