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 type of database is sql?

979

What is sql and its types?

1114

Is sql a scripting language?

924

What are the types of sql commands?

1020

Can we use delete in merge statement?

1002

Is pl sql a scripting language?

971

Differentiate between sga and pga.

1090

what is timestamp in mysql? : Sql dba

1003

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

939

How to add new employee details in an employee_details table with the following details

1043

what are the different index configurations a table can have? : Sql dba

939

what are sequences

1622

What are the differences between implicit and explicit cursors?

1004

explain what is mysql? : Sql dba

1032

What is localdb mssqllocaldb?

1017