Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [PL/SQL] getting cursor metadata

Re: [PL/SQL] getting cursor metadata

From: Marcin Zawadzki <marcinz_at_kompakt.pl>
Date: Fri, 4 Oct 2002 08:37:35 +0200
Message-ID: <anjcvk$nfu$1@news.tpi.pl>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US