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
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?
Why are you getting errors when creating a new odbc dsn?
What are types of storage modes? : sql server analysis services, ssas
What is a trace frag? Where do we use it?
What will be the maximum number of index per table?
Define cross join in sql server joins?
what are isolation levels? : Sql server database administration
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Explain syntax for dropping triggers?
What are rest-style architecture's?
How to call stored procedure using http soap?
Why and when do stored procedure recompile?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What are orphan records?
What is field with example?