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

How to find the date and time of last updated table?

Answer Posted / siddharthapenchala

select scn_to_timestamp(max(ora_rowscn)) from <TN>

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1069


Why are you getting errors when creating a new odbc dsn?

1166


What are types of storage modes? : sql server analysis services, ssas

984


What is a trace frag? Where do we use it?

1044


What will be the maximum number of index per table?

951


Define cross join in sql server joins?

964


what are isolation levels? : Sql server database administration

911


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1011


Explain syntax for dropping triggers?

885


What are rest-style architecture's?

170


How to call stored procedure using http soap?

998


Why and when do stored procedure recompile?

928


What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

977


What are orphan records?

886


What is field with example?

869