1. I used to think that Integer=number (38,0)--38 is number's maximum precision integer is a very large data type, which can be represented as power (10,126)-1 because a byte maximum represents 256, Then n bytes Max represents power (256,n) >=power (10,126) n=53, and an integer type uses a minimum of 53 bytes. So the integer type is still as small as possible, generally rarely use such a large number. In particular, some people deal with the Boolean type, because there is no Boolean type in Oracle's table structure, so many people simply replace the Boolean type with an integer, which feels a bit "extravagant". Generally, char (1) is used to denote a Boolean type; ' 0 ' means false, ' 1 ' indicates true2. VB in the ToString method home DBNull converted into an empty string. Cannot speak DBNull converted to a string method, Custom Function: public static string Getdbstring (Object obj) { if (! ( obj is DBNull)) { return (string) obj; } else { return string. Empty; }}
Processing method of integer type/dbnull in Oracle