how to get size of table field trough oracle Query -


i want size of oracle table field(column), try below query

 select data_type, data_length    user_tab_columns  table_name = 'crm_change_req'    , column_name = 'rno'; 

it gives 22 real size 4,so give suggestion can do?

check http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:10153966194688

data_length column stores maximum length in bytes required store values datatype of given column.

for number 22 bytes, regardless of precision , scale (1 byte exponent, 20 bytes mantissa , 1 byte negative sign).

for number datatype should @ data_precision , data_scale columns if want find precision , scale defined column.


Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -