Hey, my question is,
if you have a choice between declaring a cursor multiple times to return records within a nested table or make one procedure that will return a pl/sql table with the results, which would be more efficient. Obviously it would be less code writing to build a procedure to return the results, but is there anything that would make either one of these options more or less efficient.??
Any comments would be greatly appreciated..