EMPTY_BLOB

EMPTY_BLOB is an Oracle built-in function that initializes an empty BLOB (Binary Large OBject) locator for temporary use in SQL statements.

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.

For in-depth explanations and examples SQL keywords where you write your SQL, install our extension.