Answer / ajit nayak

SELECT * FROM USER_TAB_MODIFICATIONS
WHERE TO_DATE(TIMESTAMP,'DD-MON-YYYY') = TO_DATE(SYSDATE - 2,'DD-MON-YYYY');

Answer / bikash khuntia

We can check that whether the table updated on 2 days
before or not as below:-

SELECT * FROM USER_TAB_MODIFICATIONS TB
WHERE TB.table_name='TABLE_NAME'
AND TO_CHAR(TIMESTAMP,'DD')<=2

Answer / os reddy

select * from <table name>
where rownum<=2
order by last_updated_date;

OR

select * from emp where to_char(update_column,'dd')=2;

Why do we need a foreign key?

0 Answers  

---

Initially question was asked to mention the types of indexes. Then asked about BITMAP INDEX and B-Tree Index

2 Answers   Polaris,

---

Are sql connections encrypted?

0 Answers  

---

How to set up sql*plus output format in oracle?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

What is embedded sql in db2?

0 Answers  

---

Can we insert data into materialized view?

0 Answers  

---

Why do we use procedures in pl sql?

0 Answers  

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

What are different sql data types?

0 Answers  

---

how to insert the records in particular position

1 Answers  

---