How do you do the EXPLAIN of a dynamic SQL statement?
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 |
Post New Answer View All Answers
Mention the downsides of page level lock.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
List out the data types available.
What is copy pending status in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to fetch the last row from the table in SQL (db2)?
What is the maximum length of sqlca?
What are db2 objects?
What is dbrm in db2 database?
Explain the contents that are a part of dclgen.
What is db2? Explain.
What are the prerogatives?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Is the primary key a clustered index?
What is the result of open cursor statement?