1. Query dictionary xxx_dependencies, mis: dba_dependencies (untuk PLS/SQL)
.
2. Dengan DBA Studio/EM Console bisa dicheck.
3. coba script ini
SET PAGES 50
UNDEF NamaObj
SELECT LPAD(' ',(a.hirarki-1)*2)||obj.name "Nama Tabel"
FROM sys.obj$ obj,
(SELECT obj# obj#, level hirarki
FROM sys.cdef$
WHERE rcon# is not null AND robj# is not null
CONNECT BY robj# = PRIOR obj# AND robj# != obj# AND
PRIOR robj# != PRIOR obj#
START WITH robj# =
(SELECT obj# FROM sys.obj$
WHERE name = UPPER('&&NamaObj') AND type# = 2 AND
owner# = USERENV('SCHEMAID'))) a
WHERE obj.obj# = a.obj# AND obj.type# = 2
UNION ALL
SELECT LPAD(' ',(a.hirarki-1)*2)||obj.name a
FROM sys.obj$ obj,
(SELECT d_obj# obj#, level hirarki
FROM sys.dependency$
CONNECT BY p_obj# = PRIOR d_obj#
START WITH p_obj# = (SELECT obj# FROM sys.obj$
WHERE name = UPPER('&&NamaObj') AND owner# = USERENV('SCHEMAID'))) a
WHERE obj.obj# = a.obj#;
ferry sends.
----- Original Message -----
From: "siswanto" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, September 21, 2005 8:50 PM
Subject: [indo-oracle] relasi tabel oracle-9i...
> yth. Senior Indo-oracle
>
> mohon dibantu. bagaimanakah caranya mengetahui relasi antar tabel pada
> versi 9i baik primary key atau foreign key. mengingat tabel dan view
> sudah ada dan jumlahnya banyak sekali. sementara implementator tidak
> memberikan relasi tabel-tabelnya.
> demikian terima kasih bantuannya.
>
> siswanto
>
>
>
>
>
> --
> -----------I.N.D.O - O.R.A.C.L.E---------------
> Keluar: [EMAIL PROTECTED]
> Website: http://indo-oracle.lizt.org (NEW)
> -----------------------------------------------
>
> Bergabung dengan Indonesia Thin Client User Groups,
> Terminal Server, Citrix, New Moon Caneveral, di:
> http://indo-thin.vze.com
> Yahoo! Groups Links
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.lizt.org (NEW)
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.vze.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
