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 many tables will create when we create table, what are they? : Sql dba

1075

what is not null constraint? : Sql dba

1030

What is before trigger?

1004

What is a sql*loader control file?

1267

Which operator is used in query for pattern matching?

1089

What is coalesce sql?

1001

What is nosql db?

971

What is pl sql block in dbms?

1006

What is the maximum number of rows in sql table?

1030

Why do we use procedures in pl sql?

1040

Can we call stored procedure in function?

959

how can we know the number of days between two given dates using mysql? : Sql dba

1048

Who is the owner of mysql database?

1057

what is sql? : Sql dba

1030

What are stored procedures in mysql?

1019