hi,
suppose i created one table after few days i did some
insert,update how can i know when will i did ddl or dml
operation is undergone on that table
Answer Posted / gogune suresh kumar
For DDL operations query user_objects table.
For DML you need to create a trigger for that.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Which autogrowth database setting is good? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is the role of dip user in our database?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you process messages in order asynchronously?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what do you understand by fine-grained auditing?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What are the commands used in dcl? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Where do you find the default index fill factor and how to change it? : sql server DBA