What is SUBSTR function?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is SUBSTR function?
Rating:
The SUBSTR function returns a specific portion of a character string.
where,
The SUBSTR function returns a portion of str, which is n characters long, starting from position m. If m is positive, the position is counted from the beginning of the string. If m is negative, the position is counted backwards from the end of the string. If m is 0, it is treated as 1. If n is omitted, the function returns all the characters to the end of the string. The function returns NULL if n is 0 or negative.
Rating:
Was this information helpful?
Other articles
- What is TRUNCATE statement?
- What is the WITH CHECK OPTION clause?
- What is the syntax for creating an index?
- What is LEFT OUTER JOIN?
- Skills required for Oracle test 1Z0-001.