Usage of substring in oracle

The SUBSTRING function in Oracle is used to extract the specified part from a string. Syntax: SUBSTRING(string, start, length). Parameters: string - the string to extract the substring; start - the starting position of the substring; length (optional) - the length of the substring. Usage: 1. Specify the starting position and length: such as SUBSTRING('Hello World', 3, 6) returns "llo Wo"; 2. Specify the starting position without specifying the length: such as SUBSTRING('Hello World', 3) Return "llo Wor

##Usage of SUBSTRING function in Oracle

The SUBSTRING function extracts a specified portion from the given string.

<code>SUBSTRING(string, start, length)</code>

string:
• The string to extract the substring from.
start:
• The position in the string to start extracting the substring from. #length (optional): The length of the substring to extract. If omitted, the substring from the given position to the end of the string is extracted. ##How to use SUBSTRING

For example, to extract from the "Hello World" string, start at position 3 of 6 characters, you can use the following code:

<code>SUBSTRING('Hello World', 3, 6)</code>

1. Specify the starting position without specifying. Length
   

   For example, to extract the substring starting at position 3 from the "Hello World" string, you can use the following code:

   <code>SUBSTRING('Hello World', 3)</code>

   Copy after login
   This will return the substring "llo World" .

2. Truncate the end of the string
   

   For example, to truncate the last 3 characters from the "Hello World" string, you can use the following code:

   <code>SUBSTRING('Hello World', LENGTH('Hello World') - 2)</code>

   Copy after login
   This will return the substring "rld"

3. ##Tip
   

   Positional parameters start with 1, instead of 0.

If the supplied starting position exceeds the length of the string, SUBSTRING will return an empty string.

If the supplied length is negative, SUBSTRING will return an empty character. String.

<code>SUBSTRING('Hello World', -3)</code>

The above is the detailed content of Usage of substring in oracle. For more information, please follow other related articles on the PHP Chinese website!