Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> querying the data dictionary

querying the data dictionary

From: casper44 <dkniveton71_at_msn.com>
Date: 30 Mar 2002 11:04:31 -0800
Message-ID: <be3be537.0203301104.283dcd29@posting.google.com>


I have two questions on this topic.
First if I query my user_tab_columns I have about 1062 column names. How do I query to figure out which one is used the most?

Second, if I query my all_users table I get a list of about 200 users created on different dates. How do I find out which one was created most recent (by date only)? I know I can do an order by created but I lose the the top of the list because it is too long to keep in the buffer. Isn't there an easier way?

Thanks for any help on this. Received on Sat Mar 30 2002 - 13:04:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US