Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Size of a field in a table
- Thread starter rushdib
- Start date
select owner,table_name,column_name,data_length
from dba_tab_columns
where owner='OWNER_NAME'
and table_name='YOUR_TABLE'
and column_name = 'YOUR_COLUMN';
There are a number of other columns in DBA_TAB_COLUMNS which also provide useful column information.
If you don't have access to DBA_TAB_COLUMNS, because you aren't a DBA, you can probably get the same info from ALL_TAB_COLUMNS, or possibly USER_TAB_COLUMNS.
from dba_tab_columns
where owner='OWNER_NAME'
and table_name='YOUR_TABLE'
and column_name = 'YOUR_COLUMN';
There are a number of other columns in DBA_TAB_COLUMNS which also provide useful column information.
If you don't have access to DBA_TAB_COLUMNS, because you aren't a DBA, you can probably get the same info from ALL_TAB_COLUMNS, or possibly USER_TAB_COLUMNS.
- Status
