Home » SQL & PL/SQL » SQL & PL/SQL » Foreign key constraint (oracle 10.2.0.1.0,Redhat Linux 4)
Foreign key constraint [message #447826] Thu, 18 March 2010 03:21 Go to next message
goracle9
Messages: 136
Registered: December 2006
Senior Member
Dear all,

pls give the quary, to get the forignkey constraints and related table fro give table.

urget plz.
Re: FORIGNKEY CONSTRAINT [message #447829 is a reply to message #447826] Thu, 18 March 2010 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please,
1/ Do not put your title in UPPER case
2/ Try to post in english
3/ Search before posting, do you think you are the first to ask this?
4/ Post what you tried
5/ Do not post words like urgent but post in the way people will give the answer at the first post without having to ask you stuff

Regards
Michel
Re: FORIGNKEY CONSTRAINT [message #447834 is a reply to message #447826] Thu, 18 March 2010 03:36 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
You can use..
user_constraints ,user_cons_columns Two get the Information for the constraint type 'R'

sriram Smile
Previous Topic: Removing Duplicate Rows when condition is matched
Next Topic: leftouter join for below scenario
Goto Forum:
  


Current Time: Sun Dec 11 02:19:24 CST 2016

Total time taken to generate the page: 0.08404 seconds