Return to Snippet

Revision: 71930
at March 29, 2017 12:44 by bbrumm


Initial Code
/*
BFILENAME

Example 1
This example creates a directory object, and then inserts a BFILENAME into a table.
*/
CREATE DIRECTORY image_folder AS '/content/images';

INSERT INTO website_images (image_id, image_name)
VALUES (1, BFILENAME(image_folder, 'large_footer.png'));

/*
Example 2
This is an example of using BFILENAME in a SELECT statement.
*/

SELECT BFILENAME(image_folder, 'small_footer.png')
FROM dual;

Initial URL
http://www.databasestar.com/oracle-bfilename

Initial Description
A few examples of the BFILENAME function.

Initial Title
Oracle BFILENAME Function

Initial Tags
sql, Oracle

Initial Language
SQL