The NUMBER in the database of bytes-CodePudding

Recent new database, but the lecturer says only a string of bytes, NUMBER accounts for a few bytes in the database? When using integer and decimal NUMBER said byte of the same? Hope to have the great spirit guide!!!!!!

CodePudding user response:

Distribution of the number of bytes of is the same, the actual length of storage will be subject to detailed data;

 
- you look at the 

Create table test (c1 number, c2 number (18, 2), the c3 number (20, 3)); 

The begin 
Insert into test values (100100100); 
Insert into test values (1.001, 1.001, 1.001); 
Insert into test values (1.01, 1.01, 1.01); 
end; 


Select the dump (c1) c1, dump (c2) c2, dump (c3) c3 from test; 

Drop table test purge;

CodePudding user response:

reference 1st floor wmxcn2000 response:

allocated byte number is the same, the actual length of the storage, the specific data shall prevail;

 
- you look at the 

Create table test (c1 number, c2 number (18, 2), the c3 number (20, 3)); 

The begin 
Insert into test values (100100100); 
Insert into test values (1.001, 1.001, 1.001); 
Insert into test values (1.01, 1.01, 1.01); 
end; 


Select the dump (c1) c1, dump (c2) c2, dump (c3) c3 from test; 

Drop table test purge;