Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 6960 Views
- IBM, I also Faced
- E-Mail Answers
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
What is a system database and what is a user database? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
what are the differences of where and if in SAS?
What are the operating modes in which database mirroring runs? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is the use of recording information about current session?
How do you trace the traffic hitting a sql server? : sql server DBA
what functionality does oracle provide to secure sensitive information?
how does an oracle clusterware manage crs resources?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
what is ora 24313?what is the procedure to exclude that error?
What would you do with an "in-doubt" distributed transaction?
What are the commands you'd issue to show the explain plan for "select * from dual"?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
