List the tables with DML Dependencies

Author: asktom.oracle.com | Published: 20th Feb 2008 | Visited: 61 times | Add Comment
Filed in: Oracle FAQ

Using DBA_DEPENDENCIES, we can find all the dependents inside the db (procedures, triggers, packages, etc) for a given table. But now my developers want to know where (inside the db) a given table is inserted/updated/deleted - to discover that, I was...

Read Article

Sponsored Links

• Partitioning existing tables I am attempting to partition a Table T1 with existing data. Table T1 is as follows: COLUMN DATATYPE ----------------- COLUMN1 NUMBER PK COLUMN2 NUMBER COLUMN3 NUMBER I am using this approach: 1- ALTER TABLE T1 RENAME TO T1_TEMP 2- CREA ...

• [Jesper Tverskov:XSL-List] More On The Incompatibilities of XML and JSON and Why You Should Care In a follow-up conversation to the post made by Dimitre Novatchev, Jesper Tverskov provides an excellent summary as to why XML and JSON are incompatible. He goes on to describe several functions in XSLT he feels would help alleviate a ...

• [Dimitre Novatchev:XSL-List] Understanding JSON: Why JSON and XML are Incompatible and Why You Shoul... Dimitre Novatchev recently posted the following to XSL-List, something of which I thought would be of both interest and benefit to those of you in Land-O-XML who care about things kinds of things. As such, ...

• Querying SQLServer tables from within an Oracle session Dear Tom; I need to query a SQLServer table from within an Oracle session, for example SQLPlus. Is there an easy way to do this, something like: <CODE> select * from t@sql_server_link </CODE> May you redirect me to the appropriate documentati ...

• Visual Studio Project MRU List Editor II An update to a stand-alone tool for editing Visual Studio's MRU l ...

• List Comprehensions for C# 2.0 Writing nice list comprehensions for C# ...

• EventyList: The List with Events Generic list class based on Microsoft's implementation with few additional events to handle like BeforeAdd, OnAdd, BeforeRemove, ...

• Delete Links from the Recent Projects List on the Start Page of Visual Studio 2003, 2005 and 2008 This application deletes links from the Recent Projects list on the Start page of Visual Studio 2003/2005/ ...

• A generic List and Dictionary Debugger Visualizer for VS.NET Cool List and Dictionary Debugger Visualizer for VS.NET 2005 and ...

• ODP.NET - Populating a Dataset with Multiple Data Tables ODP.NET - Populating a Dataset with Multiple Data Tables Now, let us add more than one data table into a dataset The following code retrieves a list of department details into a data table named Departments and another list of employee details into a data table named Employees: Visit http://www.exf ...

Next: How to query a large table with cpu throttling