Re: oracle-l Digest V14 #334
Date: Sun, 24 Dec 2017 10:54:46 -0500
Message-ID: <b5ca7c3e-f3dc-03e9-aa89-bb49374b56a4_at_earthlink.net>
Stefan,
DBMS_METADATA can retrieve object types within DBA_OBJECTS with this query:
where get_ddl three arguments are:
On my client's 11R2 database, query above produces a decode list (0 to
101) of o.type# with human readable object_type (varchar19).
Merry Christmas,
On 12/24/2017 1:05 AM, FreeLists Mailing List Manager wrote:
SQL> set pagesize 0
SQL> set long 90000
SQL> select
2 dbms_metadata.get_ddl('VIEW', 'DBA_OBJECTS', 'SYS')
3 from dual;
1- object type (table, index, view)
2- object name
3- schema owner
> oracle-l Digest Sat, 23 Dec 2017 Volume: 14 Issue: 334
>
> In This Issue:
> Oracle TYPE# to human readable name
>
> ----------------------------------------------------------------------
>
> From: Stefan Knecht <knecht.stefan_at_gmail.com>
> Date: Sat, 23 Dec 2017 19:50:39 +0700
> Subject: Oracle TYPE# to human readable name
>
> Hi all
> Does anyone know of a structure (table, fixed table, anything) that has a
> mapping of all the object types known to the present Oracle version?
>
> What I'm looking for is basically a list, a mapping, of all possible values
> of obj$.type# and their human-readable counterpart. If you look at the
> definition of the DBA_OBJECTS view, it's basically in there with a DECODE()
> on type#. But I'd rather refrain from parsing that if I can help it.
>
> Is this data available anywhere within Oracle?
>
> Cheers
>
>
>
> Stefan
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 24 2017 - 16:54:46 CET