You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for BFILENAME


1 to 20 of 54 results. Previous page Prev  Next next page
Results per page:   20  | 40


SQL Reference, 10g Release 1 (10.1)

BFILENAME

BFILENAMESyntax bfilename::= Description of the illustration bfilename.gif Purpose BFILENAME returns a BFILE … them as arguments to BFILENAME in a SQL or PL/SQL statement, DBMS_LOB package, or OCI operation. You … case and a quoted identifier in the CREATE DIRECTORY statement, then when using the BFILENAME … example inserts

Application Developer's Guide - Large Objects, 10g Release 1 (10.1)

4 LOBs in Tables

Initializing BFILEs to NULL or a File NameA BFILE can be initialized to NULL or to a filename. To do so, you can use the BFILENAME() function. See Also: "BFILENAME() and Initialization".

Programmer's Guide, 10g Release 1 (10.1)

7 LOB and BFILE Operations

Associating a BFILE in a Table with an Operating System FileThe BFILENAME() function can be used in an INSERT statement to associate an external server-side … (operating system) file with a BFILE column/attribute in a table. Using BFILENAME() in an UPDATE … . OCILobFileSetName() can also be used to associate a BFILE in a table with an operating system file. BFILENAME() is … Objects for

Developer's Guide, 10g Release 1 (10.1)

4 XMLType Operations

Selecting XML Data Using XMLType Member FunctionsVALUES ( xmltype ( bfilename('XMLDIR','purchaseOrder.xml'), nls_charset_id('AL32UTF8') ) ); 1 row … ', xmltype ( bfilename('XMLDIR','purchaseOrder.xml'), nls_charset_id('AL32UTF8') ) ); 1 row created

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

13 Large Objects (LOBs)

13.2 How to Use LOBsFILEEXISTS() DESCRIBE FILEGETNAME() DESCRIBE FILEISOPEN() DESCRIBE FILEOPEN() OPEN BFILENAME() FILE SET … () WRITE Footnote  1  From dbmslob.sql. All routines are prefixed with 'DBMS_LOB.' except BFILENAME … . Footnote  2  The BFILENAME() built in SQL function may also be used. Note: You must explicitly lock the

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

16 Large Objects (LOBs)

16.2.1 Three Ways to Access LOBsOCILobFileOpen FILEOPEN() OPEN OCILobFileSetName BFILENAME() FILE SET Foot  3  OCILobFlushBuffer - FLUSH … with 'DBMS_LOB.' except BFILENAME. Footnote  3  T he BFILENAME() built in SQL function may also be

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBfileinformation for known image attributes: DECLARE img_attrib CLOB; data BFILE:= BFILENAME('IMAGEDIR

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

13 Large Objects (LOBs)

13.2.2 Initializing a LOB… Alternatively, you can use the BFILENAME('directory', 'filename') function in an INSERT or UPDATE statement to … physical directory and filename: EXEC SQL INSERT INTO file_table (a_bfile) VALUES (BFILENAME('lob_dir … ', 'image.gif')) RETURNING a_bfile INTO:A-BFILE END-EXEC. Note: BFILENAME() does not check permissions on

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

16 Large Objects (LOBs)

16.2.3 Initializing a LOBthe BFILENAME('directory', 'filename') function in an INSERT or UPDATE statement to initialize a … filename: EXEC SQL INSERT INTO file_table (a_bfile) VALUES (BFILENAME('lob_dir', 'image.gif … ')) RETURNING a_bfile INTO:bfile. Note: BFILENAME() does not check permissions on the directory or filename

Developer's Guide, 10g Release 1 (10.1)

3 Using Oracle XML DB

Accessing Oracle XML DB Repository Programmatically', bfilename('XMLDIR','DocExample01.txt'), nls_charset_id('AL32UTF8')); end; / PL/SQL procedure successfully completed.

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

Security ModelBFILENAME function in the Oracle Database Application Developer's Guide - Large Objects and the

Developer's Guide, 10g Release 1 (10.1)

3 Using Oracle XML DB

Loading XML Documents into Oracle XML DB Repository; begin res:= dbms_xdb.createResource('/home/SCOTT/purchaseOrder.xml', bfilename('XMLDIR

Developer's Guide, 10g Release 1 (10.1)

2 Features of OraOLEDB

LOB Support, topomap) VALUES (158, BFILENAME('mapdir', 'topo158.tps')) For more information on LOBs, see Oracle Database Application Developer's Guide - Large Objects.

Reference, 10g Release 1 (10.1)

SI_StillImage Object Type

content; fils BFILE:= BFILENAME('FILE_DIR','keyboard.jpg'); myimage SI_StillImage; BEGIN -- Put the blob in … SI_ChgContent( ) procedure: DECLARE newcontent BLOB; fils BFILE:= BFILENAME('FILE_DIR','keyboard.jpg

JDBC Developer's Guide and Reference, 10g Release 1 (10.1)

14 Working with LOBs and BFILEs

14.6.3 Creating and Populating a BFILE Columncolumn, use the bfilename function to specify the directory alias and the name of the BFILE file … . cmd ="INSERT INTO my_bfile_table VALUES ('one', bfilename(test_dir, 'file1.data'))"; stmt.execute … (cmd); cmd ="INSERT INTO my_bfile_table VALUES ('two', bfilename(test_dir, 'jdbcTest.data

Developer's Guide, 10g Release 1 (10.1)

3 Using Oracle XML DB

Using SQL Constraints to Enforce Referential IntegrityINTO PURCHASEORDER VALUES ( xmltype ( bfilename('XMLDIR','InvalidReference.xml'), nls_charset_id … ); Table altered. -- INSERT INTO PURCHASEORDER VALUES ( xmltype ( bfilename('XMLDIR','purchaseOrder.xml … ( bfilename('XMLDIR','DuplicateReference.xml'), nls_charset_id('AL32UTF8') ) ); INSERT INTO PURCHASEORDER … PURCHASEORDER VALUES

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDVideo Object Type Relational Interface

ctx; ctx RAW(64):=NULL; vid_data BFILE:= BFILENAME('VIDEODIR','testvid.dat'); vid_format VARCHAR2(160

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBfile32 pixels in the destination image: DECLARE dest_attrib CLOB; image_data BFILE:= BFILENAME('IMAGEDIR

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBfileimg_data BFILE:= BFILENAME('IMAGEDIR','testimg.dat'); img_attrib CLOB; mimeType VARCHAR2(80); width

Packages and Types Reference, 10g Release 1 (10.1)

45 DBMS_LOB

External LOBsDIRECTORY object and the filename of the external LOB you are adding to the BFILENAME function to