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;

How to Declare Fixed Length String Value In PL SQL

0 Answers  

---

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

---

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers  

---

What is rtm stands for?

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

What is package in pl sql?

0 Answers  

---

Does db2 use sql?

0 Answers  

---

how to create object in plsql

2 Answers   TCS,

---

real time applications of nullif?

3 Answers  

---

What is a schema in sql?

1 Answers  

---

What is the difference between a primary key and a clustered index?

0 Answers  

---