Monday, 27 August 2012

Mark for review Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition? | Oracle

A. SELECT &1, "&2"FROM &3 WHERE last_name = '&4';
B. SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';
C. SELECT &1, &2 FROM &3 WHERE last_name = '&4';
D. SELECT &1, '&2' FROM EMP WHERE last_name = '&4';

Ans:C

No comments: