How to find the date and time of last updated table?
- 4 Answers
- 6158 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 ? | 2 Yes | 7 No |
Post New Answer View All Answers
Is oracle a programming language?
What are the data types in oracle?
Explain the use of record length option in exp command.
What is an oracle recycle bin?
How to call a stored function with parameters?
How to end the current transaction in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What are the differences between char and varchar2 in oracle?
What is the quickest way to export a table to a flat file?
What is the usage of merge statement?
Describe the types of sub query?
What is system global area (sga) in oracle?
What are the uses of synonyms?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
What is meant by raw datatype?
