Tambahan : Coba script utldtree.sql di ORAHOME\RDBMS\ADMIN ferry sends.
----- Original Message ----- From: "Ferry" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, September 22, 2005 12:32 PM Subject: Re: [indo-oracle] relasi tabel oracle-9i... > 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 > > > > > > > > > > > > > > > -- > -----------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 --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
