kalo visualnya mungkin bisa menggunakan E/R Studio..Embarcadero...reverse engineering
> 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 > > > > > > > > > > > > > > > > > > > -- > -----------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 > > > > Visit your group "indo-oracle" on the web. > To unsubscribe from this group, send an email > to: [EMAIL PROTECTED] Your use > of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > > > ------------------------ 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/
