Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between normal select query and
currosor
- 2 Answers
- 17591 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jagan
using select in embedded sql with where clause should fetch
only one row , but cursor can be used when we need more rows
to be retrieved one at a time.
In case more than one row is retrieved in a select clause it
will throw -811 sql error.
| Is This Answer Correct ? | 28 Yes | 5 No |
Answer / vinay srivastava
Normal select Query fetches all rows in one go while cursor
fetches one row at a time.
| Is This Answer Correct ? | 10 Yes | 17 No |
What do you need to do before you do EXPLAIN ?
What is the difference between cursor stability and repeatable read isolation levels?
Explain the EXPLAIN statement?
Give some example of statistics collected during RUNSTATS?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
How are write I/Os from the buffer pool executed?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
difference between group clause and order clause
What is a result table?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
How is deadlock resolved?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
COBOL 
