如果是一位数字，如何在数字前面添加空格? [英] How do I add a space in front of my number if it is a single digit?

问题描述

正在处理当前如下所示的报告:

Working on a report that currently looks like this:

5 - Kirk Korver, UMKC
15 - Kendall Anthony, Richmond

Players With 30:
41 - Matt Staff, Texas State

我想使其如下所示:

  5 - Kirk Korver, UMKC
 15 - Kendall Anthony, Richmond

Players With 30:
41 - Matt Staff, Texas State

*notice how the dashes are in line

我可以使用pl/sql中的内置函数吗?

Is there a built in function in pl/sql that I can use?

推荐答案

尝试一下:

LPAD(player_number, 2,' ')

这篇关于如果是一位数字，如何在数字前面添加空格?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！