SQL substr function
SQL Substr function will return a sub string of a specified length from the source string beginning at a given position.
As we can see SQL substr function takes 3 parameters. First one is Source string from which you want to extract the segment.
Second parameter is Starting position for sub string from the Source string.
And the third parameter is Substr_length which is the length for the substring.
First two parameters are mandatory to specify while third one is optional.
For Oracle Aggregate Functions, please check out at • aggregate functions
On this page of the site you can watch the video online Oracle Database11g tutorials || Oracle SQL substr function with a duration of hours minute second in good quality, which was uploaded by the user Helping families make smart insurance decisions 24 January 2021, share the link with friends and acquaintances, this video has already been watched 60 times on youtube and it was liked by 6 viewers. Enjoy your viewing!