Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [PL/SQL] getting cursor metadata
> On the theory that if you teach a man to fish he can feed himself ...
>
> SELECT object_name, object_type
> FROM all_objects
> WHERE object_name LIKE '%OPEN%CURSOR%';
Thanks a lot
I 'm going to fish now.
BTW It's the very nice query.
MZ Received on Fri Oct 04 2002 - 01:37:35 CDT
![]() |
![]() |