InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Difference Between Substr And Instr? |
|
Answer» INSTR function search string for sub-string and RETURNS an integer indicating the position of the character in string that is the FIRST character of this occurrence. SUBSTR function return a PORTION of string, BEGINNING at character position, substring_length characters long. SUBSTR calculates lengths using characters as defined by the input character set. INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence. SUBSTR function return a portion of string, beginning at character position, substring_length characters long. SUBSTR calculates lengths using characters as defined by the input character set. |
|