Posted By

bbrumm on 03/29/17


Tagged

sql Oracle


Versions (?)

Oracle BFILENAME Function


 / Published in: SQL
 

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

A few examples of the BFILENAME function.

  1. /*
  2. BFILENAME
  3.  
  4. Example 1
  5. This example creates a directory object, and then inserts a BFILENAME into a table.
  6. */
  7. CREATE DIRECTORY image_folder AS '/content/images';
  8.  
  9. INSERT INTO website_images (image_id, image_name)
  10. VALUES (1, BFILENAME(image_folder, 'large_footer.png'));
  11.  
  12. /*
  13. Example 2
  14. This is an example of using BFILENAME in a SELECT statement.
  15. */
  16.  
  17. SELECT BFILENAME(image_folder, 'small_footer.png')
  18. FROM dual;

Report this snippet  

You need to login to post a comment.