help regaring the foreign key

[snehal k]

Hi all,

I need help regaring the foreign key concept in oracle.
the scenario in my case is a table as temp_table has an attribute as 'temp_id' which is being reffered by more than 2 tables as foreign key. I want ot know the names of those tables which refers this attribute as foreign key.
I just want to know is it possible to get this info using PLSQL.

Thanks in advace,

Regards,
Snehal K

[milonov]

Hello, Snehal,

perhaps a thread below may help you:
http://www.thescripts. com/forum/thread553124.ht ml

Best Regards,
Michael Milonov

http://www.snotratech.com

Hi all,

I need help regaring the foreign key concept in oracle.
the scenario in my case is a table as temp_table has an attribute as 'temp_id' which is being reffered by more than 2 tables as foreign key. I want ot know the names of those tables which refers this attribute as foreign key.
I just want to know is it possible to get this info using PLSQL.

Thanks in advace,

Regards,
Snehal K

[snehal k]

Hello, Snehal,

perhaps a thread below may help you:
http://www.thescripts. com/forum/thread553124.ht ml

Best Regards,
Michael Milonov
http://www.snotratech.com

Hello Sir,

It woks perfect way that i want.
Thanks a lot.