You will likely want to use the table all_all_tables joined with
all_constraints (constraint_type = 'R' is foreign_key)
Constraint_type definitions
http://www.remote-dba.cc/int_316.htm
all_constraints table description
http://www.ss64.com/orad/ALL_CONSTRAINTS.html
all_all_tables table description
http://www.ss64.com/orad/ALL_ALL_TABLES.html
James Clark
-----Original Message-----
From: Shahid Akhtar Khan
[mailto:oracledba-ezmlmshield-x97406109.[Email address protected]
Sent: Wednesday, March 05, 2008 2:48 AM
To: LazyDBA Discussion
Subject: need select query
Hi there
i need a select query in which i need all tables in a schema in
master-child order.
pls help .
Thanks & regards,
Shahid Akhtar Khan
Database Administrator
Xavient Information Systems
D - 42, Hosiery Complex
Phase-II, Noida
Phone (O):91-120-4670900 Extn - 946
Fax: 91-120-2461970
Mobile: 98188-76554
Visit us: www.xavient.com <blocked::http://www.xavient.com/>
Email: [Email address protected] <blocked::mailto:[Email address
protected]
========================================================================
===================================
This communication & accompanying documents ("this e-mail") contains
confidential and/or privileged information for exclusive use of the
individual to whom it is addressed. If you are not the intended
recipient, please immediately notify the company & delete this e-mail.
Any unauthorized use or disclosure of this e-mail is strictly
prohibited. Representations in this e-mail are subject to contract. As
an e-mail user please be cautious of the technical & other
vulnerabilities of the internet which may result in malicious and/or
unauthorized access to / use / alteration of e-mails/e-mail IDs. Thank
you.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page