PL/SQL (MOSC)

MOSC Banner

Requirement to split the number value ,add a space and display with remaining values

edited Dec 3, 2013 3:34AM in PL/SQL (MOSC) 10 commentsAnswered
Hello All,
I have an requirement to split the number ,modify it and display with remaining values.

e.g. the no is- 1234561
and we want to display it like this- 12 34561

Now the requirement is to split it from left to right till 5 digits ,add a space and display the remaining values.
I have tried using substr function but it did not work.
Can anyone guide me how to do that?

Thanks,
Joohi

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center