Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Mismatch on Oracle columns length !!!

Henrique Silva_3
Regular Advisor

Mismatch on Oracle columns length !!!

 
"to be or not to be, what was the question ???? "
4 REPLIES
Steve Steel
Honored Contributor

Re: Mismatch on Oracle columns length !!!

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
If you want truly to understand something, try to change it. (Kurt Lewin)
Henrique Silva_3
Regular Advisor

Re: Mismatch on Oracle columns length !!!

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
"to be or not to be, what was the question ???? "
Steve Steel
Honored Contributor

Re: Mismatch on Oracle columns length !!!

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
If you want truly to understand something, try to change it. (Kurt Lewin)
Henrique Silva_3
Regular Advisor

Re: Mismatch on Oracle columns length !!!

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
"to be or not to be, what was the question ???? "