Mismatch on Oracle columns length !!!

[Steve Steel]

Hi

18 is Octal 22 . Maybe that


Regards

Steve Steel

Quote of the moment
-------------------
"We are drowning in information but starved for knowledge."
-- John Naisbitt

[Henrique Silva_3]

I do not think so.

I think it has to do with how this allocated internally in oracle.

I am thinking that it allocates so many bytes, and for anything below 22, it will always allocate 22 bytes. I guess I will create a bogus table and check the column lengths and see if I can see a pattern.

Cheers,

Henrique

[Steve Steel]

Hi

The nulls at each end seem to cause see decode


Regards

Steve Steel

Quote of the moment
-------------------
"We are drowning in information but starved for knowledge."
-- John Naisbitt

[Henrique Silva_3]

oralce allocates variable lenght bytes for number data type up to 38 digits of precision.

see article below :

http://www.kevinloney.com/free/howlong.doc

so, it shows up as 22 ( bytes ) but it does not mean it has allocated 22 bytes when the number is actually used !!!

Nothing like answering your own question :-)

Thanks,

Henrique Silva