How does Oracle extract numbers after the decimal point?

In Oracle, you can use the SUBSTR and INSTR functions to extract the numbers after the decimal point.

Here is an example:

SELECT SUBSTR(your_column, INSTR(your_column, '.') + 1) AS decimal_part
FROM your_table;

In the example above, you need to replace “your_column” and “your_table” with the column and table names from which you’d like to extract numbers after the decimal point.

This will return the result containing the decimal part of the number.