Hi
My requirementin oracle is given number:=c1234567c
Given format:=cnn(space)nnn(space)(space)nnc or
Cnn nnn nnc
C123 456 7c
Given format (space)(space)cnnn(space)nnnnc : C123 4567c
Display given number in the given format.
Given format depends upon the requirement dynamically.
We must display number in format given.i tried by writing function using regular expression.but didnot get the required output.
Please suggest the solutions