Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
General
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 ???? "