SELECT * FROM USER_TAB_MODIFICATIONS WHERE TO

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

Question Posted / ajit nayak

Answer Posted / ajit nayak

SELECT * FROM USER_TAB_MODIFICATIONS
WHERE TO_DATE(TIMESTAMP,'DD-MON-YYYY') = TO_DATE(SYSDATE - 2,'DD-MON-YYYY');

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does postgresql compare to "nosql"?

1086

Is there a 64 bit version of ssms?

997

what is the difference between char_length and length? : Sql dba

1110

What are pl/sql cursors?

1101

What is a trigger in sql?

1234

what are all the different types of indexes? : Sql dba

1104

The select into statement is most often used to create backup copies of tables or for archiving records?

1116

What is column?

1033

Can you load data into multiple tables at once? : aql loader

1118

What is error ora-12154: tns:could not resolve the connect identifier specified?

1125

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1224

What is record in pl sql?

1140

what are the differences between char and varchar? : Sql dba

1119

What is time based sql injection?

1035

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2552