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 the default fill factor value? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what is the use of ocr?
What is a system database and what is a user database? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What is transparent data encryption? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
How do you trace the traffic hitting a sql server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba