The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints
A. 6789
B. 2345
C. 1234
D. 456789
Answer:A
The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints
A. 6789 B. 2345 C. 1234 D. 456789
Explanation: SUBSTR are used to match the particular characters in a string.