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
- 9118 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
Why do we use function in pl sql?
Mention what does the hierarchical profiler does?
Are dml statements autocommit?
Can we rename a column in the output of sql query?
Why are cursors used?
Which is faster truncate or drop?
how is myisam table stored? : Sql dba
How many types of keys are there in sql?
What is execute immediate?
How to add a column ‘salary’ to a table employee_details?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
How do you remove duplicate records from a table?
What is a parameter query?
Can we use join in subquery?
What is the use of pl/sql table?
