You want to write a query that prompts for two column names and the where condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
To achieve the desired behavior, we need to use double ampersands (&&) for the variables that should prompt only once and create a session variable, and single ampersands (&) for the variables that should prompt every time the query is executed. Option D correctly uses &table, which will prompt for the table name the first time and uses &&col1 and &&col2 for the columns, and &&condition for the where condition, ensuring they are prompted for each time but use session variables. Therefore, option D is the correct answer.
D &prompts always, && prompts once as it created a session variable
D is the answer
D is the correct answer
D is the correct answer
D is correct
D is the answer
D is the answer
D is the correct answer
C is correct look the question the where condition each time it is executed in a session but only prompts for the table name the first time it is executed.
Which is exactly why D is the answer http://its-all-about-oracle.blogspot.com/2013/07/vs-in-oracle.html