Posts tagged ‘Oracle Database 1Z0-051 Practice Test Questions’

March 30th, 2018

Oracle Database 1Z0-051 Practice Test Questions

Share more Oracle Database 1Z0-051 Practice Test Questions

You need to extract details of those products in the SALES table where the PROD_ID column contains the string ‘_D123’.
Which WHERE clause could be used in the SELECT statement to get the required output?
A. WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘_’
B. WHERE prod_id LIKE ‘%\_D123%’ ESCAPE ‘\’
C. WHERE prod_id LIKE ‘%_D123%’ ESCAPE ‘%_’
D. WHERE prod_id LIKE ‘%\_D123%’… Continue reading