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
- 9094 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
What is trigger and stored procedure in sql?
What is inner join in sql?
Why query optimization is needed?
Why is theta join required?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How do you drop a trigger?
What is rownum?
What are different types of keys?
What is the use of desc in sql?
What is trigger in flip flop?
Which is better join or subquery?
What does 0 mean in sql?
Which join is like inner join?
What is relationship? How many types of relationship are there?
