Re: ressources of desc

From: Alexander Medvedev <a.medvedev_at_globalone.ru>
Date: Mon, 09 Oct 2000 15:06:26 +0400
Message-ID: <39E1A6B2.BEC1EC4@globalone.ru>

bombart_at_my-deja.com wrote:

> Hello,
>
> do you know the ressources using by desc?
> Are these perhaps views, or some system tables?
> I would use the desc funktionality in a plsql procedure.
> Using dynamic SQL with DBMS_SQL is not suitable.
>
> Thank you in Advance
>
> Thomas Bombardi
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Hi, you may investigate the dictionary contents by select * from dict; you will find some useful comments on
the main Oracle catalog views.
I guess what you want are user_objects and user_tab_columns views.

Regards Alexander Medvedev Received on Mon Oct 09 2000 - 06:06:26 CDT