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.
Márcio de Souza Almeida
DBA Oracle / SQLServer / PostgreSQL
Rua Cupa, 139 Apto 85 A
Penha - São Paulo - SP
03640-000 - Brasil
Click Here to Expand Forum to Full Width