write a query find which rows of a table is updated on 2
days before?
- 3 Answers
- 8430 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 use of package in pl sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How to sort the rows in sql.
Are null values same as that of zero or a blank space?
What is trigger with example?
How does cross join work?
What happens when a trigger is associated to a view?
Is there a 64 bit version of ssms?
How much ram can sql express use?
How can you create an empty table from an existing table?
What is dml and ddl?
How many sql statements are used? Define them.
what are enums used for in mysql? : Sql dba
Why partition by is used in sql?
what is 'trigger' in sql? : Sql dba
