Category Archives: Datatype

Loading a File Into a BLOB Object in Oracle

Posted on August 18, 2009 by ryelpango

Loading a file into a BLOB object in Oracle is easy. All we need to do is use the DBMS_LOB package to load the file into a temporary LOB object. This is demonstrated in the following example. This example assumes … Continue reading →

Posted in BLOB, Load File Into BLOB, Oracle, PL/SQL | Tagged , | 4 Comments

Oracle VARCHAR2(1) vs CHAR(1)?

Posted on August 17, 2009 by ryelpango

Well, minimum size for both Oracle datatypes is 1 byte. So in terms of storage, they’ll both consume either null or 1 byte in storage space. So, when declaring a character datatype with a length of 1, it doesn’t really … Continue reading →

Posted in CHAR, Datatype, Oracle, VARCHAR2 | Tagged , , | Leave a comment