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
What is dcl? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
what is logical system in sap basis
how can you schedule a job in database?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What would you do with an "in-doubt" distributed transaction?
how can you communicate with operating system files from oracle?
What the different types of replication and why are they used? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
You create a private database link and upon
connection, fails with: ORA-2085: connects to
what is asm?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?