EMPTY_BLOB

Oracle

EMPTY_BLOB() RETURN BLOB;

Example

DECLARE
   my_blob   BLOB;
BEGIN
   my_blob := EMPTY_BLOB();
END;

Output

No output is expected from this operation as it is just assigning an empty blob to a variable.

Explanation

In this example, EMPTY_BLOB() function is used to initialize my_blob variable to hold an empty large binary object (BLOB). The EMPTY_BLOB() function in Oracle SQL returns a locator that points to an empty or uninitialized LOB.