What will be the output of the following query?select INSTR('Tech on the net', 'e', 1, 3) from dual;21114

The output of the query will be 11.

Here's the step by step explanation:

1. The INSTR function in SQL is used to find the position of a substring in a string.

2. The syntax of the INSTR function is: INSTR(string, substring, start_position, nth_occurrence)

3. In your query, the string is 'Tech on the net', the substring is 'e', the start_position is 1 (which means start from the beginning of the string), and the nth_occurrence is 3 (which means find the position of the 3rd occurrence of 'e').

4. The first 'e' is found at position 2, the second 'e' is found at position 5, and the third 'e' is found at position 11.

5. Therefore, the output of the query is 11.