Advanced Search

Oracle BFILENAME Function

/ Published in: SQL
Save to your folder(s)
A few examples of the BFILENAME function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.