My Oracle Support Banner

Regarding OSA Conditions (Doc ID 2804874.1)

Last updated on MAY 16, 2023

Applies to:

Oracle Stream Analytics - Version and later
Information in this document applies to any platform.


New requirement from Business is that have to remove leading 0's from String in OSA.

Customer have tried multiple things:

1. Tried to convert string into int, its not possible as value may contains characters as well.
2. Unable to implement this - trim(TO_CHAR(trim(LEADING 0 FROM a.POS_ID))) its working in oracle db
3. Tried replacing string with "^0+" this regex. replace(terminalId,"^0+","")- its not working giving same result as 0013445

Need help on this.
OSA Version -


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.