Saturday, 25 August 2012

Which of the following queries can you use to search for employees with the pattern 'A_B' in their names? | Oracle


A. SELECT last_name FROM employees WHERE last_name LIKE '%A\_B%' ESCAPE '\\';
B. SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE;
C. SELECT last_name FROM employees WHERE last_name LIKE 'A_B%' ESCAPE '%';
D. SELECT last_name FROM employees WHERE last_name LIKE '%A\_B%' ESCAPE '\';

Ans:D

No comments: