we could replace the unknown values with a "?" eg: select nam

How do you do the EXPLAIN of a dynamic SQL statement?

Question Posted / swetha dasari

Answer Posted / swetha dasari

we could replace the unknown values with a "?"
eg:

select name

from database

where name = ?

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

can all users have the privilage to use the sql statement select * (dml)?

1223

What is isolation level in db2?

1069

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1246

How do I change the column size in db2?

1208

Is schema the same as database?

1107

What are db2 tables?

1165

Which component is responsible for processing sql statements and selecting access paths?

1178

What is the cobol picture clause of the db2 data types date, time, timestamp?

1123

Explain dclgen.

1272

How to compare data between two tables in db2?

1139

Explain various types of locks in db2?

1207

Explain db2.

1087

What is the clustering index in the db2 database?

1047

What are the contents of a dclmgen?

1176

What is the use of db2?

1114