How to extract a digit from number in oracle?

@shyann 

You can extract a digit from a number in Oracle using the following SQL query:

1
2

SELECT SUBSTR('12345', 3, 1) AS extracted_digit
FROM DUAL;

In this query, '12345' is the number from which you want to extract the digit, 3 is the starting position of the digit you want to extract, and 1 is the number of characters to extract.

This query will extract the digit '3' from the number '12345' and return it as the result.