BFILENAME |
BFILENAME(directory, filename) |
Returns a BFILE locator that points to a file that you specify.
Parameters
directory
Specifies a directory, previously created using the CREATE DIRECTORY statement that contains the file.
filename
Specifies a name of the file to which you want the locator to point. Note that you can create locators to files that do not exist.
Example
DECLARE admin_photo BFILE; BEGIN admin_photo := BFILENAME('/home/oracle','administrator_ photo.jpg'); ... END;
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.