Home » RDBMS Server » Server Utilities » Space utilisation for number.
Space utilisation for number. [message #198967] Thu, 19 October 2006 07:38 Go to next message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Hi All,

After creating the following table.

create table NUMBERTEST (x integer, y number(38), z number(20,0), w number(2)) ;

If you see that y is declared as number(38). Would each value in this field actually occupy 38 bytes or would it occupy only it needs? In the sense would it behave like varchar2?


By the way, how do I find the space utilisation for a table?

Thanks,
Sunil

Report message to a moderator

Re: Space utilisation for number. [message #199052 is a reply to message #198967] Thu, 19 October 2006 20:33 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
It only occupies the space it needs. You can measure the space used by any value with the VSIZE() function.
Ross Leishman

Report message to a moderator

Re: Space utilisation for number. [message #199257 is a reply to message #199052] Sun, 22 October 2006 22:55 Go to previous message
msgforsunil
Messages: 26
Registered: November 2005
Junior Member
Thanks. Will look into VSIZE() functionality.

Report message to a moderator

Previous Topic: Getting to know size of tables from Dump?
Next Topic: How to load substr via sql loader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 15:49:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.