This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hello, I have a problem to get the exact size of result set. Let us assume that my query get 20 results and another query get 30 results, now how can i adjust the size of my collection (array) dynamically to adjust w.r.t result set size. I use some technique that first get the count then perform another query for results , but this does not seems to be a good technique because there are some restriction of using ORACLE COUNT METHOD. Can any one give me the best practices for setting collection(array) size w.r.t the result set size. thanks and best regards. Faisal Ishaque