write a query find which rows of a table is updated on 2
days before?
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 are views in sql?
What is user in sql?
Can function return multiple values in sql?
What is pl sql package?
Explain what is a subquery ?
Why do we use joins?
Explain table and field in sql?
Which join is default?
How do you take the union of two tables in sql?
what is datawarehouse? : Sql dba
What is snowflake sql?
What are records give examples?
What is a sql profiler?
What are pl/sql cursor exceptions?
Explain ttitle and btitle.