| DOUBT IN USER_TAB_COLUMNS [message #259560] |
Thu, 16 August 2007 00:12  |
meeta
Messages: 28
Registered: January 2000
|
Junior Member |
|
|
Hi,
I have 1 small doubt in contents of table USER_TAB_COLUMNS
DATA_LENGTH shows the length of columns in byte and for number columns it is DATA_PRECISION, But for number columns only there is some value in DATA_LENGTH column, what is that value
eg->
SQL>SELECT * FROM USER_TAB_COLUMNS WHERE TABLE_NAME='ABC';
TABLE_NAME COLUMN_NAME DATA_TYPE DATA_LENGTH DATA_PRECISION
ABC SAL NUMBER 22 6
SQL>Desc ABC
SAL NUMBER(6)
I want to ask what is this 22 in DATA_LENGTH column
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
