Oracle Command LPAD

March 29, 2013 10:44 pm Published by

Il comando LPAD รจ ulizzato per formattare un campo con in determinato segnaposto.

Sintassi:
LPAD(<campo1>,<numero_cifre>,<segnaposto>)

esempio:

SELECT LPAD( DUMMY,9,'0') FROM DUAL

Categorised in: , ,

This post was written by admin

Comments are closed here.