Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: execute immediate for cursor
There's no such thing as a simple SQL Statement
it's not clear what you want to do ....
Having being forced from the first time I met Oracle to write mode 4 pro C
I'd advise the declare prepare fetch open .... It teaches you manners anyway
"mariusz" <on_at_wp.pl> wrote in message news:ahj5ti$37i$1_at_news.tpi.pl...
> Hi,
> Id' like to make a cursor:
> cursor (ptable_name in varchar2) cu is select * from ptable_name; --
> Error!!
> I know that if I whant to do that in simple sql statemant, I can use:
> execute immediate:
> execute immediate 'select * from '||ptable_name;
> But, How to use it in cursor?
> Thanks very much for your help!!
>
> Mariusz G.
>
>
>
>
Received on Tue Jul 23 2002 - 04:34:05 CDT