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

What do you mean by cursor?

950

Before you give the explain statement, what are the prerogatives?

982

What is the advantage in De-normalizing tables in DB2?

1126

What are packages in db2?

982

How do we specify index to include or not during bind process.

2082

Is the primary key a clustered index?

1086

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1052

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

1065

How do I connect my db2 database to ibm?

996

What is the use of reorg in db2?

1030

What is the syntax for creating a table in the db2 database?

1066

What os does db2 run on?

936

What is buffer pool?

1037

What is with ur in db2?

1255

Explain what are the various isolation levels possible?

995