-
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.
Regards,
Abhi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|