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
- 9067 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
Can pl sql procedure have a return statement?
Is join an inner join?
What is where clause in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What are sql data types?
how would concatenate strings in mysql? : Sql dba
Why is stored procedure faster than query?
Why is a trigger used?
What does truncate mean in sql?
explain what is mysql? : Sql dba
What are the different schemas objects that can be created using pl/sql?
What is sqlca in powerbuilder?
What is the difference between syntax error and runtime error?
What type of database is cloud sql?
what is sql? : Sql dba
