Select question

Hi,

Would you please let me know if there is a way that I could use SELECT on a CURSOR. Say I have a cursor declared as follows:

cursor CUSTOMER_CUR IS
SELECT name, phone_num
FROM customer;
......

I want to be able to select from this cursor without looping though it. Can I use something like this:

SELECT CUSTOMER_CUR.NAME
FROM (DUAL??) Any tip would be appreciated

Thanks Received on Mon Aug 21 2000 - 12:23:52 CDT