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
- 6959 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
who owns the operating system files created by the utl_file package?
How would you go about verifying the network name that the local_listener is currently using?
What is dcl? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how can you get actual data change values from previous transactions in oracle?
Can you redefine a table online?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What are the commands used in dcl? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
Where do you find the default index fill factor and how to change it? : 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
What is fill factor? : 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?
how can you initialize log miner?
