Answer / ajit nayak

SELECT * FROM USER_TAB_MODIFICATIONS
WHERE TO_DATE(TIMESTAMP,'DD-MON-YYYY') = TO_DATE(SYSDATE - 2,'DD-MON-YYYY');

Answer / bikash khuntia

We can check that whether the table updated on 2 days
before or not as below:-

SELECT * FROM USER_TAB_MODIFICATIONS TB
WHERE TB.table_name='TABLE_NAME'
AND TO_CHAR(TIMESTAMP,'DD')<=2

Answer / os reddy

select * from <table name>
where rownum<=2
order by last_updated_date;

OR

select * from emp where to_char(update_column,'dd')=2;

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

Is it important to partition hard disk?

0 Answers  

---

What is the difference between microsoft access and sql server?

0 Answers  

---

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

---

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

---

---

What are the three forms of normalization?

0 Answers  

---

how many columns can be used for creating index? : Sql dba

0 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

how can we know the count/number of elements of an array? : Sql dba

0 Answers  

---

What are the packages in pl sql?

0 Answers  

---

How do I trace sql profiler?

0 Answers  

---

what is difference between delete and truncate commands? : Sql dba

0 Answers  

---