oracle中是否有任何函数可以保持字符串长度固定？

I have a scenario like when a column value exceeds the length of 10 characters, I need to take a sub-string for only 10 characters (left most) but if it is shorter than that it should be left padded with zeroes. I tried the following:I have a scenario like when a column value exce