Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zihancool

    PL/SQL simple question, thanks in advance

    Hi Carp Thanks for your reply, I believe your suggestion is a smart way to solve my issues, because there is no synchronize issues for the time window, but I want to know what is the performance comparison between this collection way and two sqls implementation, could you tell me more? thanks.
  2. zihancool

    PL/SQL simple question, thanks in advance

    Hi SantaMufasa Great explanation!!! I thought it's simple but actually not, my issue is that the number of row which being returned from the cursor will have different meaning to my business, so I need to know the number before I populate the cursor, but never mind, I will try some other way to...
  3. zihancool

    PL/SQL simple question, thanks in advance

    Hi Mufasa thanks for your reply, but running two sql select statements for this requirement is what I want to avoid in my code, so any other suggestion?
  4. zihancool

    PL/SQL simple question, thanks in advance

    I am new of PL/sql, my question is how do I know how many rows inside a cursor without fetch them in a loop. thanks.

Part and Inventory Search

Back
Top