object dependencies

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc

Poston Wed, 19 Jan 2005 4:24 pm

How to know if there is any function or object on the basis that has dependency of your procedure for example
Code: Select all
select name, type
from user_dependencies
where referenced_name = 'nome_obj'
now saw this and decided to post one of those hehehe good for someone aí ...

[] ':
Location: Videira - SC

Poston Wed, 19 Jan 2005 4:45 pm

Way to go!!!

I have a script that helps me in time to search the data dictionary tables: viewtopic.php?t=11 [] s ´
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?

  • See also
    Last Post

Return to SQL

Who is online

Users browsing this forum: Bing [Bot] and 2 guests