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 -> Re: Why I don't use all_tab_columns

Re: Why I don't use all_tab_columns

From: M. Stratford <mark.stratford_at_misys.com>
Date: 9 Jan 2003 05:28:39 -0800
Message-ID: <2bcc2302.0301090528.4372968f@posting.google.com>


the distinction is:

ALL_TAB_COLUMNS - columns of all tables/views *accessible* to the user. USER_TAB_COLUMNS- columns of tables/views *owned* by the current user.

and the most useful:

DBA_TAB_COLUMNS - columns of *all* tables/views

mark stratford Received on Thu Jan 09 2003 - 07:28:39 CST

Original text of this message

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