How to extract the string before a comma in Oracle?

2 years ago
Isabella Edwards
1 minute

In Oracle, you can use the SUBSTR and INSTR functions to extract the string before the comma.

The specific steps are as follows:

  1. Use the INSTR function to locate the position of the first comma in the string.
  2. Use the SUBSTR function to retrieve the substring from the beginning of the string up to right before the comma.

Here is an example:

SELECT SUBSTR(column_name, 1, INSTR(column_name, ',')-1) AS substring
FROM table_name

Please replace column_name with the name of the string column to be truncated, and table_name with the corresponding table name.

This will return the substring before the comma.

bannerAds