Re: diffrence between Select * from tab and Cat

From: HansF <News.Hans_at_telus.net>
Date: Thu, 19 May 2005 12:43:23 GMT
Message-Id: <pan.2005.05.19.12.46.00.839946@telus.net>

On Thu, 19 May 2005 05:12:24 -0700, Surendra Panwar interested us by writing:

It is possible you are looking at obsolete dictionary descriptors - tab was short for TABLES and cat was short for CATALOG. IIRC, the main difference was that cat included views. If so, be aware that neither of these is in common use today as they both have serious limitations in the information they present.

If that is the case, and tab shows a list of tables, you are encouraged to learn Oracle's current methods by looking at the Oracle 'Database Reference' document found in http://docs.oracle.com

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***

Received on Thu May 19 2005 - 07:43:23 CDT