We can check that whether the table updated on 2 days before or not as be

write a query find which rows of a table is updated on 2
days before?

Question Posted / bikash khuntia

3 Answers
8949 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

Please Help Members By Posting Answers For Below Questions

What are the two types of cursors in pl sql?

1004

What is difference between procedure and trigger?

919

What is the difference between drop and truncate commands?

999

What are the types of index in sql?

1016

Is left join and outer join same?

1006

What is the usage of nvl function?

984

What is trigger in pl sql with examples?

982

Is left join faster than inner join?

1065

What is the need of merge statement?

989

How do you take the union of two tables in sql?

934

What is sql architecture?

984

How many sql statements are used? Define them.

983

What is offset and limit in sql?

1002

What are the advantages of normalization?

1040

What is online transaction processing (oltp)?

962