What is the default value of OCI_ATTR_TOP_RCNT?
Answer.The default value is 1, that is, one extra row per fetch. If you are not using array fetch and set the value to 1, it reduces the round-trips for fetching a result set to half the number of rows. Setting the value to 1 also helps cancel the result set when there is just one row to be fetched.
Related Questions
- I need greater accuracy in the FDR value than that afforded by the default number of 5 randomizations. Can I compute the FDR value using more randomizations than the default number?
- Can I specify a default value of "SYSDATE" (the current date) for a report parameter?
- What default value is best for the User Code fields?
