Shulou(Shulou.com)06/01 Report--

Select length ('abc'), lpad (' abc',4,'$'), lpad ('abc',5,' ^'), lpad ('abc',5,'gf'), lpad (' abc',10,'gf') from dual

The lpad function populates the string on the left with specific characters with the syntax format as follows:

Lpad (string,n, [pad_string])

Lpad (field name, fill length, filled character)

String: but characters or parameters

N: the length of the character is the number of strings returned. If this number is shorter than the length of the original string, the lpad function will truncate the string into n characters from left to right.

Pad_string: is an optional parameter. The string is to be pasted to the left of string. If this parameter is not written, the lpad function will paste a space to the left of string.

Query results:

The usage of the Rpad () function:

The rpad function populates the string on the right with specific characters with the syntax format as follows:

Rpad (string,n, [pad_string])

String: but characters or parameters

N: the length of the character is the number of strings returned. If this number is shorter than the length of the original string, the lpad function will truncate the string into n characters from left to right.

Pad_string: is an optional parameter. The string is to be pasted to the right of string. If this parameter is not written, the lpad function will paste a space to the right of string.

Select length ('abc'), lpad (' abc',7,'&'), rpad ('tech', 1) from dual

Query results:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.