BLOB « Large Objects « Oracle PL/SQL Tutorial

34.3.1.Creating Tables Containing BLOB Objects
34.3.2.Initialize BLOB column data
34.3.3.Adding Content to a BLOB
34.3.4.Use update statement to change the value in blob type column
34.3.5.UPDATE sets blob_column to a binary number:
34.3.6.Open the BLOB
34.3.7.Loading a page to a BLOB
34.3.8.Populating a BLOB column from an external BFILE
34.3.9.INSERT a row with an empty blob

34.3.10.Display the length of the BLOB
34.3.11.Obtain length of the populated BLOB
34.3.12.Close the BLOB