ExamVeda
Login
Home
This question belongs to SQL Sql Miscellaneous
Sql Miscellaneous
?

The SQL statement
SELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;
prints

Answer & Solution
Correct Answer: Option A

Another form of INSTR function used in ORACLE is:
INSTR (str, pattern, [starting position, [nth location]]): Finds the starting location of the nth occurrence of pattern beginning in the starting position-th position in string str.
Example: - SELECT INSTR('kolkata', 'a', 1, 2) FROM DUAL;
will output 7 as the starting location of 2nd occurrence of pattern 'a' from starting position 1 in string 'kolkata' is 7.

In the above query INSTR('123321234', '2', 3, 2) will give the output 7 as the starting location of 2nd occurrence of pattern '2' from starting location three in string '123321234' is 7.

Now SUBSTR function becomes SUBSTR('abcdefghij

Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
Swati Kumari
Swati Kumari 6 years ago
Thank you for this well explained in a easy way