Interested to Buy Any Domain ? << Click Here >> for more details...
write a query find which rows of a table is updated on 2
days before?
- 3 Answers
- 9225 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Explain select statements in sql?
Determine if oracle date is on a weekend?
How can we find duplicate records in a table?
What normalization means?
Why we use pl sql?
Can I create table without primary key?
Enlist the characteristics of pl/sql?
Is left join faster than inner join?
What are inner and outer joins examples of both?
What is coalesce in sql?
Is inner join same as self join?
Define tables and fields in a database
What is the purpose of using pl/sql?
What is a call statement? Explain with an example.
What is compilation error in pl sql?
