Oracle TYPE# to human readable name
From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sat, 23 Dec 2017 19:50:39 +0700
Message-ID: <CAP50yQ_yPdcmFPpZHYg+=NYo0R0vJJdZFtTBe0oye_de5ke1Dw_at_mail.gmail.com>
Hi all
Date: Sat, 23 Dec 2017 19:50:39 +0700
Message-ID: <CAP50yQ_yPdcmFPpZHYg+=NYo0R0vJJdZFtTBe0oye_de5ke1Dw_at_mail.gmail.com>
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
-- // zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework! Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat | _at_zztat_oracle -- http://www.freelists.org/webpage/oracle-lReceived on Sat Dec 23 2017 - 13:50:39 CET