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
- 5583 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / prashe
select OWNER,OBJECT_NAME,CREATED,LAST_DDL_TIME,from
dba_objects where OBJECT_NAME='&object_name';
for DDL command.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What types of replication are supported in sql server? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
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 is a user-defined lock?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the different types of upgrades that can be performed in sql server? : sql server DBA
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
what is a crs resource?
how does an oracle clusterware manage crs resources?
How would you extract DDL of a table without using a GUI tool?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
