Hi ,

Thanks a lot.


Kind regards,
Raj




"Raj " <r.[Email address protected]
05/07/2007 06:45 PM

To
KIDAMBI.[Email address protected]
cc

Subject
Re: Used by ---Tables,Procedures






**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Hi,
SELECT * FROM ALL_DEPENDENCIES WHERE REFERENCED_NAME='<TABLE_NAME>'

Will show the Procedures/ Functions that using the specified table.


Regards,

Raj




----- Original Message -----
From: "kidambi" [Email address protected]
To: "LazyDBA Discussion" [Email address protected]
Sent: Monday, May 07, 2007 6:07 PM
Subject: Used by ---Tables,Procedures


> Hi all,
>
> Any query by which we can find out the procedures or functions
(involving)
> being used by a table.
>
> Thanks
>
>
> Kind regards,
> Raj
>
>
> This e-Mail may contain proprietary and confidential information and is
> sent for the intended recipient(s) only. If by an addressing or
> transmission error this mail has been misdirected to you, you are
> requested to delete this mail immediately. You are also hereby notified
> that any use, any form of reproduction, dissemination, copying,
> disclosure, modification, distribution and/or publication of this e-mail

> message, contents or its attachment other than by its intended
recipient/s
> is strictly prohibited.
>
> Visit us at http://www.polaris.co.in
>
>
> ---------------------------------------------------------------------
> 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
>
>





This e-Mail may contain proprietary and confidential information and is sent for the intended recipient(s) only. If by an addressing or transmission error this mail has been misdirected to you, you are requested to delete this mail immediately. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail message, contents or its attachment other than by its intended recipient/s is strictly prohibited.

Visit us at http://www.polaris.co.in

Oracle LazyDBA home page