Menu
Home / CSE MCQs / Oracle Database MCQs :: Discussion

Discussion :: Oracle Database MCQs

  1. The SQL statement 

    SELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL;
    2. A.
    6789
    B.
    2345
    C.
    1234
    D.
    456789

    View Answer

    Workspace

    View Answer

    Answer : Option B

    Explanation :

    INSTR function in SQL is used to find the starting location of a pattern in a string. The syntax for the INSTR function is as follows:INSTR(str,pattern):Find the starting location of pattern in string str and SUBSTR Function:- The Substring function in SQL is used to grab a portion of the stored data.

Write your comments here:

Be The First To Comment