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
what method you can use to reduce the overhead of Reporting Services data sources?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
How can I check that whether automatic statistic update is enabled or not?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How to throw custom exception in Stored Procedure?
What is the user of Primary key?
How do you send email on SQL Server?
Differentiate between SQL and ORACLE joins and write their syntax.
How to delete database objects with "drop" statements in ms sql server?
What is resource governor?
How do triggers work?
What happens if we shrink log file in sql server?
What is the difference between online clustering and Offline clustering?
Why can there be only one clustered index and not more than one?
What does set rowcount do?