Home » MCQs » Oracle MCQs » Oracle LIKE Condition MCQs

Syntax of LIKE condition –

3. Syntax of LIKE condition -

1. expression LIKE pattern 
2. LIKE expression pattern [ESCAPE 'escape_character' ]
3. expression ESCAPE pattern [LIKE 'escape_character' ]
4. expression LIKE pattern [ESCAPE 'escape_character' ]

Answer: D) expression LIKE pattern [ESCAPE 'escape_character' ]

Explanation:

Syntax of LIKE condition is:

expression LIKE pattern [ESCAPE 'escape_character']