Sorting in oracle plsql tables
Hi Oracle Gurus,
I have two queries for you.
1. Is it possible to have sort operation on an associative array or a plsql table?
2. I am using bulk collect and limit keyword to fetch records into a plsql table for a DB table.The DB table has over 100000 records. What is the optinum value of limit I can put so as to not to hamper performance. I reckon fetching the whole table into the plsql table will cause performance issue. I need to process the data and sort them too.
Please suggest. Thanks in advance.
Click Here to Expand Forum to Full Width