Using the SUBSTR() Oracle Function

Using SUBSTRING() in the SELECT clause

The SUBSTR() function is used to extract a character string from a given starting position for a given length. 

SELECT  
        SUBSTR(COURSE_DESIGNATER,6,3) as "Course number"                   
FROM    COURSES
WHERE   COURSE_DESIGNATER LIKE 'Excel%' 

Format a column using SUBSTR() and LOWER() and UPPER() functions

It is possible to use the Oracle LOWER() and UPPER() functions in conjunction with the SUBSTR() function to accomplish different types of formatting.

SELECT 
  UPPER(SUBSTR(lastname,1,1)) || LOWER(SUBSTR(lastname,2,29)) 
  AS "Lastname"
FROM Students

• Basic DML
  • SQL Select
  • SQL Update
  • SQL Insert
  • SQL Delete
• Functions
  • Substring function
  • Upper and Lower functions
  • RTRIM and LTRIM functions

Oracle Information and Resources