SUBSTR() Character Function — Oracle SQL Example

Joshua Otwell
Level Up Coding
Published in
4 min readMay 12, 2021

--

Manipulating string or character data is a bread-and-butter practice in programming. There are a plethora of requirements, reasons, and use cases in which you might need to slice and dice a string character value. The Oracle SQL SUBSTR() function can be used to extract specific portions of a string. If you are unfamiliar with SUBSTR(), continue reading further to learn more about it, and add this handy function to your SQL toolbelt.

Image by Gerd Altmann from Pixabay

--

--

SQL | PHP | Photography. Sign-up for my free developer newsletter, OpenLampTech, here: openlamptech.substack.com