Oracle的BLOB空值
Oracle的BLOB空值
01 Create table b(id varchar,obj blob); 02 Insert into b(id) values(“A”); 03 Insert into b(id,obj) values(“B”,empty_blob()); 04 Insert into b(id,obj) values(“C”,’’); 05 Insert into b(id,obj) values(“D”,null); 06 Select id,obj from b; 07 id obj length 08 ----------------------------------------- 09 A 0x 0 10 B 0x 0 11 C 0x 0 12 D NULL NULL