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
- 7123 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
how can you get actual data change values from previous transactions in oracle?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What purpose does the model database server? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : 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?
who owns the operating system files created by the utl_file package?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Query processing is slow(eg select query)how will u solve that
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
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 do you understand by flashback feature of oracle?
what is grd?
