RelationalDBDesign
Search
SiteMap
Advanced Oracle Tuning
Advanced SQL
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Network Administration
Oracle Network Topology
Oracle SQL Tuning
8i PL/SQL Programming
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Managing DB Objects
Oracle Space Management
Managing Oracle Tables
Data dictionary views about tables and columns
Mapping of characteristics:
TABLE_NAME
Contains the name of the table
AVG_ROW_LENGTH
A column in the
USER_TABLES
view
DATA_TYPE
A column in the
USER_TAB_COLUMNS
view
ALL_TABLES
Lists the tables in all the schemas the current user has access to
COLUMN_NAME
Contains the name of the columns in the
USER_TAB_COLUMNS
view
USER_TABLES
Lists the tables in the current user's schema
