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

Explain about dbrm.

1048

what is the responsibility of the construction superintendent

2147

Explain in detail about buffer manager and its functionalities?

1066

What is explain in db2?

1022

what is the sqlcode -501

13154

What is dbrm? What it contains? When it will be created?

1051

Explain the contention situations caused by locks?

1070

Is ibm db2 free?

1013

What is netezza database?

1028

How can you find out the # of rows updated after an update statement?

1116

How to execute stored procedures?

1130

What is cascading rollback?

1214

What is concurrency?

1234

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1272

What is a system catalog table in db2?

1186