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
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is snapshot report?
How to list all stored procedures in the current database using ms sql server?
What do you understand by the denormalisation?
What do you mean by stored techniques? How would we use it?
Differentiate between a primary key and a unique key.
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
explain extended properties
Explain time data type in sal server 2008?
When do you think a developer should use sql server-based cursors?
How to update muliple row in single query?
What are the different types of subquery?
What is spatial and temporal data?
What is a non equi join?