Re[2]: SOLVED: How to define a Type with multiple columns ,for bulk fetch
- From: Edgar Chupit <chupit@xxxxxx>
- To: Juan Cachito Reyes Pacheco <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 22:14:21 +0200
Hello Juan,
JCRP> Yes, but create an object for every specific select, that gathers specific
JCRP> columns, you will have lot and lot of objects.
And alternatively you can do it like this:
SQL> get 1.sql
1 declare
2 cursor c is select object_name from all_objects;
3 type row_type is table of c%rowtype index by binary_integer;
4 r row_type;
5 begin
6 open c;
7 fetch c bulk collect into r limit 100;
8 close c;
9 dbms_output.put_line( r.count );
10* end;
11 /
100
PL/SQL procedure successfully completed.
--
Edgar
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Re[2]: SOLVED: How to define a Type with multiple columns ,for bulk fetch