Which command is used to remove all rows from a table?
No Answer is Posted For this Question
Be the First to Post Answer
can we drop column from a table
What is the difference between SYNONYM and ALIAS?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
what is the process of precompiler?
What is the purpose of the WHENEVER statement?
Outputs of explain are with matchcols = 0. What does this signify?
What type of database is db2?
What is buffer pool and list some of them?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?