Dynamic Cursor In Pl/sql

Dynamic Cursor in PL/SQL

Here we'll Retrive all Accounts Belongs to The Customer (10021)
Ex:

declare
CURSOR c (id_in IN NUMBER) IS
SELECT acount_no FROM accounts
WHERE customer_no = id_in;
begin
for r in c(10021) loop
dbms_output.put_line(r.acount_no);
end loop;
end;





Output:

0110021002 --(Account #1)
0210021001 --(Account #2)
0110021000 --(Account #3)