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

What is function and procedure?

986


What are sql procedures?

967


What is the sql*loader? : aql loader

1006


What is pl sql quora?

1072


How do I run a sql script?

1056


What is ttitle and btitle?

1006


Are subqueries faster than joins?

955


What does stand for in sql?

920


Does normalization improve performance?

982


How many clustered indexes can be created on a table?

1024


What is synchronized subquery?

1093


What are sql indexes?

938


What is parallel hint?

1223


Can we perform dml on view?

976


What does trigger mean in slang?

1007