Oracle LPAD function example: How to pad specified characters on the left side of a string

Title: Oracle LPAD function example: How to pad specified characters on the left side of a string

The LPAD function in Oracle database is a method used to pad the left side of a string Functions that fill in specified characters can help us format strings. The syntax of the LPAD function is: LPAD (string to be filled, total length, filling characters). Next, we demonstrate how to use the LPAD function in Oracle through specific code examples.

First, we create a sample table test_table to demonstrate the use of the LPAD function:

CREATE TABLE test_table (
    id NUMBER,
    name VARCHAR2(50)
);

INSERT INTO test_table VALUES (1, 'Tom');
INSERT INTO test_table VALUES (2, 'Jerry');
INSERT INTO test_table VALUES (3, 'Alice');

Next, we use the LPAD function to left-fill the name field and add each string The padding is 10 characters, the padding character is "*", and the result is displayed as a new column:

SELECT id, name, LPAD(name, 10, '*') AS padded_name
FROM test_table;

After executing the above SQL statement, we can get the following results:

ID  NAME    PADDED_NAME
1   Tom     *******Tom
2   Jerry   *****Jerry
3   Alice   *****Alice

From As can be seen from the above results, the LPAD function successfully pads the left side of the original string to the specified length and uses the specified characters. In this way, we can more conveniently control the format when outputting, comparing or other operations on strings.

To summarize, this article demonstrates through specific code examples how to use the LPAD function to perform left-side padding on strings in the Oracle database. The LPAD function is one of the commonly used string processing functions in Oracle databases. It can help us format strings and improve the beauty and readability of data display. I hope this article can be helpful to readers when using Oracle database in actual work.

The above is the detailed content of Oracle LPAD function example: How to pad specified characters on the left side of a string. For more information, please follow other related articles on the PHP Chinese website!