Perfect. There is also another, extended version of
substring. Take a look:
SELECT substring(name, 2, 3) AS name_substring
In the above example, substring received an additional number (3). In this way, we can specify the length of the substring we want to get. For the name 'TripCare', we'll get 'rip', because we start at letter 2 (which is 'r') and take 3 of them('r', 'I' and 'p').
Again, if you start from a number which exceeds the length of the whole string, you will get an empty string. If the second number you provide is bigger than the length to the end of the string, the database will simply return the string until its end.
However, in Oracle this function is called