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
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: 3727
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
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.
Previous Topic: Insert diacritic marks
Next Topic: execute immediate with Alter user statement
Goto Forum:
  


Current Time: Sun Aug 20 21:37:50 CDT 2017

Total time taken to generate the page: 0.00996 seconds