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...

in table there r so many rows write a query which two rows r
updated last two day befor?

Answer Posted / ashok kumar lenka

We can solve this by the help of Trigger.
The trigger is for update.which store the update time of the
record of the table. So my query is like this
>select * from emp where to_char(update_column,'dd')=2;

Is This Answer Correct ?    10 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why stored procedure is better than query?

948


Explain what is dbms?

1067


Why do we use joins?

1040


Explain what is rdbms?

1037


What is bind reference and how can it be created?

1020


How to run pl/sql statements in sql*plus?

1079


What is pl/sql table? Why it is used?

1036


what are all different types of collation sensitivity? : Sql dba

982


What is online transaction processing (oltp)?

1017


What is a composite primary key?

1095


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1036


what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1130


What is the most common sql injection tool?

1041


what is a relationship and what are they? : Sql dba

1101


How can get second highest salary in sql?

988