What is SUBSTR in SQL? The SUBSTR function in Oracle SQL is used to extract a specific part of a string. It is one of the most commonly used SQL string functions, especially in: Data cleaning, code ...