How to get value from string sequence column in oracle?

@filiberto 

To get value from a string sequence column in Oracle, you can use the SUBSTR function to extract a specific substring from the column. Here's an example:

Let's say you have a table called "my_table" with a column called "string_seq" that contains a sequence of characters like "ABC123DEFG456HIJ". If you want to extract the numeric value "456" from the string, you can use the following SQL query:

1
2

SELECT SUBSTR(string_seq, INSTR(string_seq, '456'), 3) AS extracted_value
FROM my_table;

In this query:

• SUBSTR is used to extract a substring from the "string_seq" column.
• INSTR is used to find the starting position of the substring '456' in the column.
• The third argument in SUBSTR specifies the length of the substring to extract, which is 3 in this case.

This will return the extracted numeric value "456" from the "string_seq" column in your Oracle database. You can adjust the query parameters based on the specific requirements of your data.