Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Views in all_tab_columns? (Read 6784 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Views in all_tab_columns?
08.10.08 at 11:31:02
 
Views in all_tab_columns?
 
The name all_tab_columns seems to imply it contains all the column information of tables. It also contains information about views and clusters!
 
Oracle documentation:
ALL_TAB_COLUMNS describes the columns of the tables, views, and clusters accessible to the current user.  
 
Related views:
DBA_TAB_COLUMNS describes the columns of all tables, views, and clusters in the database.
USER_TAB_COLUMNS describes the columns of the tables, views, and clusters owned by the current user. This view does not display the OWNER column.
 
Comment:
To gather statistics for this view, use the ANALYZE SQL statement or the DBMS_STATS package.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1