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