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

What are different types of indexes?

1053

What is a pragma statement?

1332

What is the execution plan in sql?

1067

Explain the purpose of %type and %rowtype data types?

973

how to shutdown mysql server? : Sql dba

1142

What do you mean by stored procedures?

1065

Can we insert data into materialized view?

989

How to test for null values?

1092

What is a pdo connection?

1109

Why do we need unique key in a table?

1002

How do I create a sql script?

1140

How much does sql cost?

1064

how would you enter characters as hex numbers? : Sql dba

1033

Advantages and disadvantages of stored procedure?

1165

How to run pl sql program in mysql?

1069