Home » Developer & Programmer » Designer » Storage space consumed by NUMBER datatype
Storage space consumed by NUMBER datatype [message #90704] Thu, 19 August 2004 06:21 Go to next message
Kenny Rodman
Messages: 1
Registered: August 2004
Junior Member
Hi... I am developing my Oracle database on Oracle 8i... in my database I have various columns that are defined as NUMBER(38)... in some instances, the largest number to be stored in these columns is 255, so three digits max... if I am only storing 3 digits in a column defined as NUMBER(38), is there a lot of wasted storage?? Or does Oracle only provide storage space for the data and not the column?

cheers, Kenny
Re: Storage space consumed by NUMBER datatype [message #90705 is a reply to message #90704] Thu, 19 August 2004 10:44 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Previous Topic: A logical design and its problems?!
Next Topic: migration
Goto Forum:
  


Current Time: Sun Nov 24 04:21:58 CST 2024