Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 9267 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj
select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
In case you have filters in your report, when filters will be applied in cached report instance?
Explain four layers of abstraction microsoft architectured?
What is molap and its advantage? : sql server analysis services, ssas
What is a cache in ssrs?
How to remove duplicate rows from table?
How to add additional conditions in SQL?
Can I disable or restrict ssrs export formats (rendering formats)?
How to use the inserted and deleted pseudo tables?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are the advantages of using a stored procedure?
What is sql server programming?
Is it important for a database administrator to understand the operating system and file access?
How to delete duplicate records based on single column from a table?
What happens when unicode strings concatenate with non-unicode strings?
What is difference between commit and rollback when used in transactions?
