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..
The procedure is very speed.
But you can use VIEW.