Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Loop a PL/SQL collection (Read 1812 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Loop a PL/SQL collection
15.07.11 at 13:22:27
 
Loop a PL/SQL collection
 
declare
 TYPE T_TYPE IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
 t t_type;
 i number;
begin
 i := t.first;
 loop
   exit when i is null;
   dbms_output.put_line(t(i));
   i:= t.next(i);
 end loop;
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1