PLSQL | LN Function

PLSQL | LTRIM Function

Last Updated : 24 Sep, 2019

The PLSQL LTRIM function is used for removing all specified characters from the left-hand side of a string. The PLSQL LTRIM function accepts two parameters which are input_string and trim_string.

If the user does not specify trim_string, it defaults to a single blank.
If char is a character literal, then you must enclose it in single quotes.

Oracle Database begins scanning char from its first character and removes all characters that appear in trim_string until reaching a character not in trim_string and then returns the result. Syntax:

LTRIM( input_string [, trim_string] )

Parameters Used:

input_string - It is used to specify the string whose characters need to be trimmed from the left hand side.
trim_string - It is an optional parameter which is used to specify the string that will be removed from the left-hand side of string1. If this parameter is omitted, the LTRIM function removes all leading spaces from input_string.

Supported Versions of Oracle/PLSQL:

Oracle 12c
Oracle 11g
Oracle 10g
Oracle 9i
Oracle 8i

Example-1:

DECLARE 
   Test_String string(25) := '    Geeksforgeeks';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String)); 
   
END;

Output:

Geeksforgeeks

Example-2:

DECLARE 
   Test_String string(25) := '    Geeksforgeeks';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String, ' ')); 
   
END;

Output:

Geeksforgeeks

Example-3:

DECLARE 
   Test_String string(25) := '123Geeksforgeeks';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String, '123')); 
   
END;

Output:

Geeksforgeeks

Example-4:

DECLARE 
   Test_String string(25) := '123123Geeksforgeeks';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String, '123')); 
   
END;

Output:

Geeksforgeeks

Example-5:

DECLARE 
   Test_String string(25) := '123Geeks123forgeeks';
   
BEGIN 
   dbms_output.put_line(LTRIM(Test_String, '123')); 
   
END;

Output:

Geeks123forgeeks

PLSQL | LN Function

S

Shubrodeep Banerjee

Improve

Article Tags :

Similar Reads

SQL LTRIM() Function

The SQL LTRIM() function is an essential tool used in data cleaning and manipulation tasks. This function helps remove unwanted leading spaces or specific characters from the left side of a string or string expression. It's commonly used to tidy up data by eliminating unnecessary spaces or character

SQL RTRIM() Function

SQL RTRIM function is a string function that removes spaces from the right side of a character or string. RTRIM or Right Trim function is used in data cleaning and manipulation in SQL.In this example, we will learn the basics of the RTRIM function, and learn how it works with examples of different u

PLSQL | LN Function

The LN function is an inbuilt function in PLSQL which is used to return the natural logarithm of a given input number. The natural logarithm of a number is the logarithm of that number to the base e, where e is the mathematical constant approximately equal to 2.718. This is written using the notatio

PLSQL | LEAST Function

The LEAST is an inbuilt function in PLSQL which is used to return the least value from a given list of some expressions. These expressions may be numbers, alphabets etc. Syntax: LEAST(exp1, exp2, ... exp_n) Parameters Used: This function accept some parameters like exp1, exp2, ... exp_n. These each

PLSQL | INSTR Function

The PLSQL INSTR function is used for returning the location of a substring in a string. The PLSQL INSTR function searches a string for a substring specified by the user using characters and returns the position in the string that is the first character of a specified occurrence of the substring. The

PLSQL | LOWER Function

The PLSQL LOWER function is used for converting all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function. The char to be converted can be any of the datatypes such as CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or

LTRIM() Function in MySQL

LTRIM() : This function in MySQL is used to remove leading spaces from a string. Syntax : LTRIM(str) Parameter : It accepts one parameter as mentioned above and described below as follows. str â€“ The string from which we want to remove leading spaces. Returns : It returns a string after truncating al

PLSQL | MOD Function

The MOD function is an inbuilt function in PLSQL which is used to return the remainder when a is divided by b. Its formula is m - n * \left\lfloor\dfrac{m}{n}\right\rfloor. Syntax: MOD(a, b) Parameters Used: This function accepts two parameters a and b. This function gives remainder as the output wh

PLSQL | LOG Function

The PLSQL LOG function is used for returning the logarithm of n base m. The LOG function accepts two parameters which are used to calculate the logarithmic value. The LOG function returns a value of the numeric data type. This function takes as an argument any numeric data type as well as any non-nu

PLSQL | INSTR4 Function

The PLSQL INSTR4 function is used for returning the location of a substring in a string using UCS4 code points. UCS-4 codepoints is a character encoding which allows the representation of each value as exactly four bytes (one 32-bit word). UCS-4 represents a possible value between 0 and hexadecimal