select replicate('0', (10-len('123')))+'123'Oracle:
SELECT LPad('123',10,'0') FROM dualDB2:
values char(repeat('0',10-length('123'))||'123',10)
select replicate('0', (10-len('123')))+'123'Oracle:
SELECT LPad('123',10,'0') FROM dualDB2:
values char(repeat('0',10-length('123'))||'123',10)