•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 363,448 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,260 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 717 | Replies: 4
•
•
Join Date: Dec 2007
Location: India
Posts: 240
Reputation: 
Rep Power: 1
Solved Threads: 34
Posting Whiz in Training
Hi Guys...
i'm not so good at oracle, sql and related stuff.. but i do need to write some simple query's from time to time and i do need to understand that which all tables get updated by a particular transaction. I can do that by going through the code, but problem is i'm damn lazy and also that usually i like to automate most of this donkey work. would be great if any of you oracle guru's could tell me that is there someway i can find that which all tables got updated by a transaction. i expect some system view or some system table to contain the states of the tables(last modified) or something like that which i can query before and after i run a transaction or something on those lines.
i'm not so good at oracle, sql and related stuff.. but i do need to write some simple query's from time to time and i do need to understand that which all tables get updated by a particular transaction. I can do that by going through the code, but problem is i'm damn lazy and also that usually i like to automate most of this donkey work. would be great if any of you oracle guru's could tell me that is there someway i can find that which all tables got updated by a transaction. i expect some system view or some system table to contain the states of the tables(last modified) or something like that which i can query before and after i run a transaction or something on those lines.
Last edited by Agni : May 5th, 2008 at 12:31 am.
thanks
-chandra
-chandra
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Threaded ModeSimilar Threads
- Updated : Simple ASP.Net Login Page (ASP.NET)
- Misc programming from a novice (Site Layout and Usability)
- PHP HTTP Screen-Scraping Class with Caching (PHP)
- Need urgent help. Problem with SQL and win server. (Windows NT / 2000 / XP / 2003)
- vBulletin optimization (Search Engine Optimization)
- Updating a databound combobox (VB.NET)
- URGENT: Implementing search with multiple dissimilar MySQL tables (MySQL)
- Perplexed: Combo Box Not Holding Data (C#)
- ASP and SQL ? (MS SQL)
Other Threads in the Oracle Forum
- Previous Thread: err: identifier 'DATEADD' must be declared
- Next Thread: password for sql plus
