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 Server
  2. Suggest New Category

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

Question Posted / siddharthapenchala

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

Do you know what is sql service broker?

1086

Explain insert into select statement?

955

How do I view a trc file?

942

What are the approximate numeric data types?

936

What are different types of constraints?

922

can we have a nested transaction? : Sql server database administration

1094

What is a group function explain with an example?

989

How can sql injection be stopped? : sql server security

1036

What command do we use to rename a db, a table and a column?

927

Comment,Datatypes are unlimited

2057

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2147

How do you handle datasets larger than 50 gb?

162

How to count duplicated values in a column in ms sql server?

1092

Explain can SSRS reports Cache results?

158

What is normalization? Explain its different types?

1090