 
MariaDB RPAD_ORACLE SQL Function - Pad string on the right in Oracle mode |
|
| | RPAD_ORACLE | Syntax: | RPAD_ORACLE(String, Length, String to append) | | Return value: | CHAR | | Function type: | String function | |
| | The RPAD_ORACLE() function returns "String" with "Length" as the result, with the missing characters being filled with "String to append" on the right side.
If "Length" is less than the length of "String", "String" is returned truncated to "Length". This then corresponds to the function LEFT().
If "String to append" is not specified, the RPAD_ORACLE() function pads with spaces.
Numeric values of "String" or "String to append" are interpreted as character strings.
If "String" or "String to append" is NULL, the RPAD_ORACLE() function returns NULL.
This feature is available from MariaDB 10.3.6.
Unlike RPAD_ORACLE(), the function RPAD() returns an empty string instead of NULL, if the result is empty.
This feature is not present in MySQL 8.0. | SQL Examples for the RPAD_ORACLE function |
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
| select rpad_oracle('Test', 8, 'x');
select rpad_oracle('Test', 4, 'x');
select rpad_oracle('Test', 2, 'x');
select rpad_oracle('Test', 8, '123');
select rpad_oracle(456, 8, '123');
select rpad_oracle(456, 8, 123);
select hex(rpad_oracle('Test', 8));
select rpad_oracle('Test', 0, 'x');
select rpad_oracle('Test', 8, null);
select rpad_oracle(null, 4, 'x');
|
|
| rpad_oracle('Test', 8, 'x') |
|---|
| varchar(8) BINARY |
|---|
| Testxxxx |
|
|
| rpad_oracle('Test', 4, 'x') |
|---|
| varchar(4) BINARY |
|---|
| Test |
|
|
| rpad_oracle('Test', 2, 'x') |
|---|
| varchar(2) BINARY |
|---|
| Te |
|
|
| rpad_oracle('Test', 8, '123') |
|---|
| varchar(8) BINARY |
|---|
| Test1231 |
|
|
| rpad_oracle(456, 8, '123') |
|---|
| varchar(8) BINARY |
|---|
| 45612312 |
|
|
| rpad_oracle(456, 8, 123) |
|---|
| varchar(8) BINARY |
|---|
| 45612312 |
|
|
| hex(rpad_oracle('Test', 8)) |
|---|
| varchar(16) BINARY |
|---|
| 5465737420202020 |
|
|
| rpad_oracle('Test', 0, 'x') |
|---|
| varchar(0) BINARY |
|---|
| NULL |
|
|
| rpad_oracle('Test', 8, null) |
|---|
| varchar(8) BINARY |
|---|
| NULL |
|
|
| rpad_oracle(null, 4, 'x') |
|---|
| varchar(4) BINARY |
|---|
| NULL |
|
|
| | The examples were created with the MyWAY SQL manager: | How to use the RPAD_ORACLE() function in MariaDB databases | | In MariaDB the RPAD_ORACLE() function is used to pad strings to a specific length by adding a specific character or a specific character group is appended. The function is useful when it is necessary to ensure that a string has a certain length by adding padding characters on the right side. RPAD_ORACLE() is commonly used to format data, align text, or create fixed-length fields in reports or display output. Unlike the RPAD() function, RPAD_ORACLE() returns NULL if the result is empty. | | Further MySQL und MariaDB SQL String functions | | CHAR | CHAR(Character code, [, Charset]) | | More about CHAR Function |
| | CHR | CHR(Character code) | | More about CHR Function |
| | CONCAT | CONCAT(Strings ('str1','str2', ...)) | | More about CONCAT Function |
| | CONCAT_WS | CONCAT_WS(Separator, Strings ('str1','str2', ...)) | | More about CONCAT_WS Function |
| | ELT | ELT(Index, Strings ('str1','str2', ...)) | | More about ELT Function |
| | EXPORT_SET | EXPORT_SET(Bits, On, Off [, Separator] [, Number of bits]) | | More about EXPORT_SET Function |
| | EXTRACTVALUE | EXTRACTVALUE(XML, XPath) |
| | FIELD | FIELD(Search string, Strings ('str1','str2', ...)) | | More about FIELD Function |
| | FORMAT | FORMAT(Number, Decimals [, Region]) | | More about FORMAT Function |
| | INSERT | INSERT(String, Position, Length, String to insert) | | More about INSERT Function |
| | LCASE | LCASE(String) | | More about LCASE Function |
| | LEFT | LEFT(String, Length) | | More about LEFT Function |
| | LOAD_FILE | LOAD_FILE(File name) |
| | LOWER | LOWER(String) | | More about LOWER Function |
| | LPAD | LPAD(String, Length, String to append) | | More about LPAD Function |
| | LPAD_ORACLE | LPAD_ORACLE(String, Length, String to append) | | More about LPAD_ORACLE Function |
| | LTRIM | LTRIM(String) | | More about LTRIM Function |
| | MAKE_SET | MAKE_SET(Bits, Strings ('str1','str2', ...)) | | More about MAKE_SET Function |
| | MID | MID(String, Position [, Length]) | | More about MID Function |
| | QUOTE | QUOTE(String) | | More about QUOTE Function |
| | REPEAT | REPEAT(String, Number) | | More about REPEAT Function |
| | REPLACE | REPLACE(String, Search, Replace) | | More about REPLACE Function |
| | REVERSE | REVERSE(String) | | More about REVERSE Function |
| | RIGHT | RIGHT(String, Length) | | More about RIGHT Function |
| | RPAD | RPAD(String, Length, String to append) | | More about RPAD Function |
| | RTRIM | RTRIM(String) | | More about RTRIM Function |
| | SOUNDEX | SOUNDEX(String) | | More about SOUNDEX Function |
| | SPACE | SPACE(Number) | | More about SPACE Function |
| | SUBSTR | SUBSTR(String, Position, Length) | | More about SUBSTR Function |
| | SUBSTRING | SUBSTRING(String, Position, Length) | | More about SUBSTRING Function |
| | SUBSTRING_INDEX | SUBSTRING_INDEX(String, Delimiter, Number) | | More about SUBSTRING_INDEX Function |
| | TRIM | TRIM([Type] [, Delete character], , String) | | More about TRIM Function |
| | TRIM_ORACLE | TRIM_ORACLE([Type] [, Delete character], , String) | | More about TRIM_ORACLE Function |
| | UCASE | UCASE(String) | | More about UCASE Function |
| | UPPER | UPPER(String) | | More about UPPER Function |
| | WEIGHT_STRING | WEIGHT_STRING(String [AS Format] [LEVEL Level] [Sorting]) | | More about WEIGHT_STRING Function |
| | ASCII | ASCII(String) | | More about ASCII Function |
| | BIT_LENGTH | BIT_LENGTH(String) | | More about BIT_LENGTH Function |
| | CHAR_LENGTH | CHAR_LENGTH(String) | | More about CHAR_LENGTH Function |
| | CHARACTER_LENGTH | CHARACTER_LENGTH(String) | | More about CHARACTER_LENGTH Function |
| | FIND_IN_SET | FIND_IN_SET(Search string, Set of values) | | More about FIND_IN_SET Function |
| | INSTR | INSTR(String, Search string) | | More about INSTR Function |
| | LENGTH | LENGTH(String) | | More about LENGTH Function |
| | LENGTHB | LENGTHB(String) | | More about LENGTHB Function |
| | LOCATE | LOCATE(Search string, String [, Position]) | | More about LOCATE Function |
| | OCTET_LENGTH | OCTET_LENGTH(String) | | More about OCTET_LENGTH Function |
| | ORD | ORD(String) | | More about ORD Function |
| | POSITION | POSITION(Search string IN String) | | More about POSITION Function |
|
|
| | | More information about the RPAD_ORACLE SQL function: |
|
|
|
|
