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 nested table in pl sql?

739

Mention what pl/sql package consists of?

718

How global cursor can be declare with dynamic trigger ?

1938

Does sql backup shrink transaction log?

728

Explain some predefined exceptions.

774

how to drop an existing view in mysql? : Sql dba

787

what is a control file ? : Sql dba

759

What is trigger in pl sql with examples?

716

what is a primary key? : Sql dba

741

What is the use of partition by in sql?

706

How many types of tables are there?

690

Does varchar need length?

708

What is the use of index in hive?

725

How do I know if I have sql express or standard?

752

What are the two types of periodical indexes?

656