Re: Select question

I am not sure what you are trying to accomplish...

Why do you want to do this?

Lahcen Airir <wcis_at_accesscomm.ca> wrote:

>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 - 14:20:44 CDT