Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

System Tables - Oracle

RSS
Modified on Tue, Nov 25, 2008, 12:49 AM by Administrator Categorized as Oracle
System TableDescriptionColumns
ALL_TABLES Tables TABLE_NAME, OWNER, NUM_ROWS
ALL_TAB_COLUMNSTable Columns OWNER, TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE
ALL_INDEXESIndexes OWNER, INDEX_NAME, INDEX_TYPE, TABLE_OWNER, TABLE_NAME, UNIQUENESS
ALL_IND_COLUMNSIndex Columns INDEX_OWNER, INDEX_NAME, TABLE_OWNER, TABLE_NAME, COLUMN_NAME, COLUMN_POSITION, COLUMN_LENGTH, DESCEND
ALL_OBJECTSObjects OBJECT_NAME, OBJECT_TYPE

Valid Object Types: INDEX, SEQUENCE, TABLE, VIEW, etc.

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2018, Patrick Jasinski.