I'm stoked!!! just got my head around nested explicit cursors!

[Jasper Vader]

Yay ... although the second nested cursor is totally working properly, all it is doing right now is pulling out all the item descriptions and putting them in there, rather than the ones specific to the order...but i will fix that after i just enjoy the fact that i got it working!

  
f customer.first%TYPE;
l customer.last%TYPE;
a customer.address%TYPE;
c customer.city%TYPE;
s customer.state%TYPE;
z customer.zip%TYPE;
o cust_order.order_id%TYPE;
d cust_order.order_date%TYPE;
it_desc item.item_desc%TYPE;
CURSOR order_c IS
select order_id, order_date 
from cust_order
where cust_id = 179;
CURSOR order_items_c IS
select item_desc from item;
BEGIN
select first, last, address, city, state, zip 
into f, l, a, c, s, z
from customer
where last = 'Chang';
dbms_output.put_line(f || ' ' || l);
dbms_output.put_line(a);
dbms_output.put_line(c || ' ' || s || ' ' || z);
open order_c;
loop
fetch order_c into o, d;
exit when order_c%NOTFOUND;
dbms_output.put_line('Order ID: ' || o || '  Date: ' || d);
open order_items_c;
loop
fetch order_items_c into it_desc;
exit when order_items_c%NOTFOUND;
dbms_output.put_line('Description: ' || it_desc);
end loop;
close order_items_c;
end loop;
close order_c;
END;
/

yaaayyyyy