Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

write a query find which rows of a table is updated on 2
days before?

Question Posted / akshya

Answers were Sorted based on User's Feedback



write a query find which rows of a table is updated on 2 days before?..

Answer / 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

write a query find which rows of a table is updated on 2 days before?..

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

Is This Answer Correct ?    2 Yes 3 No

write a query find which rows of a table is updated on 2 days before?..

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;

Is This Answer Correct ?    3 Yes 10 No

Post New Answer

More SQL PLSQL Interview Questions

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

6 Answers   Accenture,

Give an example of Full Outer Join?

1 Answers   IBM,

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

What is an exception in pl/sql?

0 Answers  

What is a pragma statement?

0 Answers  

What are transaction and its controls?

0 Answers  

What is the use of function "module procedure" in pl/sql?

0 Answers  

What are stored procedures used for?

0 Answers  

What has stored procedures in sql and how we can use it?

0 Answers  

What is pl/sql language case sensitive?

0 Answers  

What does (+) mean in sql joins?

0 Answers  

Is postgresql a server?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories