Re: Designer V6 Meta Data Model

From: Frank Naude <NaudeFJ_at_telkom.co.za>
Date: Sat, 29 Apr 2000 14:50:57 +0200
Message-Id: <10482.104505@fatcity.com>

Hi Surjit, try this script:

rem -----------------------------------------------------------------------=

rem Filename: d2kcols.sql
rem Purpose: List Designer column descriptions per table

rem Date:       28-Apr-2000
rem Author:     Frank Naude (frank_at_onwe.co.za)
rem -----------------------------------------------------------------------=

break on TAB on COL

col tab format a30 trunc
col col format a30 trunc

SELECT AL2.NAME TAB,
       AL3.NAME COL,
       AL4.TXT_TEXT
FROM   CI_APPLICATION_SYSTEMS AL1,
       CI_TABLE_DEFINITIONS AL2,
       CI_COLUMNS AL3,
       CDI_TEXT AL4,
       SDD_ELEMENTS AL5
WHERE  AL1.NAME    =3D 'GOLD INT'     -- Substitute your app name ***
  AND  AL1.ID      =3D AL2.APPLICATION_SYSTEM_OWNED_BY
  AND  AL2.ID      =3D AL3.TABLE_REFERENCE
  AND  AL3.ID      =3D AL5.EL_ID

AND AL4.TXT_REF =3D AL5.EL_ID
ORDER BY AL2.NAME, AL3.SEQUENCE_NUMBER, AL4.TXT_SEQ /

Cheers
Frank Naud=E9
* TEL: 082-3713651 / 012-6773114 (w) / 012-6652336 (h) * E-MAIL: frank_at_onwe.co.za / NaudeFJ_at_Telkom.co.za

Visit the Oracle FAQ at http://www.orafaq.org/=20

>>> surjits_at_ozemail.com.au 04/29 1:34 PM >>>
Hi

I have a requirement to write some reports from the metadata model (Oracle = Designer V 6.0) repository. In particular I am interested in a report = which has the following attributes:

Table Name
Column Name
Description of the column as entered in CASE.

I gather the tables should be SDD_ELEMENTS and CDI_TEXT however in absence = of the datamodel I am not able to get rid of the elements coming from the = frozen version of application.

Any idea as to how to write this report or where I can get the data model = (E-R Diagram) of the Case Repository. Received on Sat Apr 29 2000 - 07:50:57 CDT