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

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

748


What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

932


What is snapshot report?

138


How to list all stored procedures in the current database using ms sql server?

822


What do you understand by the denormalisation?

721


What do you mean by stored techniques? How would we use it?

785


Differentiate between a primary key and a unique key.

798


Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

762


explain extended properties

721


Explain time data type in sal server 2008?

720


When do you think a developer should use sql server-based cursors?

724


How to update muliple row in single query?

809


What are the different types of subquery?

828


What is spatial and temporal data?

716


What is a non equi join?

741