Concatenate strings in Oracle SQL without a space in between?
This is not an issue with the concatenation operator but with the function to_char()
. Try instead:
to_char(10000,'FM99999')
I quote the manual here:
FM .. Returns a value with no leading or trailing blanks.