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 is cursor and its types?

1061

What is record type in pl sql?

984

What does where 1/2 mean in sql?

1062

Which command is used to delete a trigger?

1323

What is cursor in pl sql?

1114

What are analytical functions in sql?

1023

How exception handling is done in advance pl/sql?

979

How does cross join work?

944

What is meaning of <> in sql?

1065

What is bulk collect in pl sql?

1086

What is example of database?

1049

What are the indexing methods?

1039

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

950

What is over () in sql?

948

Is id a reserved word in sql?

1141