Advanced Search

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