Revision: 71930
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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