[Oracle] Lpad函数

摘要:Oracle的Lpad函数


语法:
lpad( string1, padded_length, [pad_string] )

范例:
lpad('tech', 2)                              --'te'         
lpad('tech', 7)                              --'   tech' 前面加3个空格
lpad('tech', 8, '0')                        --'0000tech'
lpad('tech on the net', 15, 'z')   --'tech on the net'
lpad('tech on the net', 16, 'z')   --'ztech on the net'