Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"Last_Analyzed" in SQL Query Means ?

user60341Oct 29 2009 — edited Aug 15 2012
Hi All,
Can any one please let me know the Meaning or purpose of "LAST_ANALYZED" from the below Query.For what purpose we use that word and how it will work?


SELECT table_name,num_rows,last_analyzed FROM ALL_TABLES WHERE table_name like 'PYM%'


Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2012
Added on Oct 29 2009
6 comments
24,465 views