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 40 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

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDAudio Object Type Relational Interface

ctx: DECLARE aud_attrib CLOB; ctx RAW(64):=NULL; aud_data BFILE:= BFILENAME('AUDIODIR','testaud.dat

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDDoc Object Type Relational Interface

ctxknown document attributes: DECLARE doc_attrib CLOB; ctx RAW(64):=NULL; doc_data BFILE:= BFILENAME

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDDoc Object Type Relational Interface

ctxdoc_attrib CLOB; ctx RAW(64):=NULL; doc_data BFILE:= BFILENAME('DOCDIR','testvid.dat'); doc_format

GeoRaster, 10g Release 1 (10.1)

4 SDO_GEOR Package Reference

r_sourceFormat:= '/parrot.tif'; file:= BFILENAME('BLOB_TEST_ONE', fileName); wfname:= '/parrot.tfw'; wfile:= BFILENAME

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

2 Working with LOBs

Initializing a LOB Column to Contain a Locator, EMPTY_BLOB(), 'my Oracle', EMPTY_CLOB(), EMPTY_CLOB(), NULL, NULL, BFILENAME('directory_object … file by using the BFILENAME () function. See Also: "Accessing BFILEs" for more information on initializing BFILE columns.

Reference, 10g Release 1 (10.1)

SI_StillImage Object Type

contentBLOB; fils BFILE:= BFILENAME('FILE_DIR','window.psp'); newimage SI_StillImage; height NUMBER; width … , width) function: DECLARE lobd BLOB; fils BFILE:= BFILENAME('FILE_DIR','window.psp'); newimage

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

3 Using Oracle XML DB

Loading XML Content into Oracle XML DB Using SQL or PL/SQL-3 Inserting XML Content into an XMLType Table INSERT INTO example2 VALUES ( xmltype ( bfilename … fileContent CLOB:= NULL; file bfile:= bfilename(directoryName,filename); dest_offset number:= 1

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDAudio Object Type Relational Interface

ctxaud_attrib CLOB; ctx RAW(64):=NULL; data BFILE:= BFILENAME('AUDIODIR','testaud.dat'); mimeType VARCHAR2

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

11 Accessing and Manipulating Oracle Data

11.3.2 Oracle getOracleObject() MethodVALUES ('one', bfilename ('TEST_DIR', 'file1'))"); ResultSet rset = stmt.executeQuery ("SELECT * FROM

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

2 Fundamentals of the PL/SQL Language

Summary of PL/SQL Built-In FunctionsBFILENAME COALESCE DECODE DUMP EMPTY_BLOB EMPTY_CLOB GREATEST LEAST NANVL NLS_CHARSET_DECL_LEN

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

3 Using Oracle XML DB

Using the Database to Enforce XML Data Integrity( bfilename('XMLDIR','Invoice.xml'), nls_charset_id('AL32UTF8') ) ); INSERT INTO PURCHASEORDER

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDVideo Object Type Relational Interface

ctxknown video attributes: DECLARE vid_attrib CLOB; ctx RAW(64):=NULL; vid_data BFILE:= BFILENAME

Reference, 10g Release 1 (10.1)

SI_StillImage Object Type

contentlobd blob; fils BFILE:= BFILENAME('FILE_DIR','speaker.jpg'); BEGIN DBMS_LOB.CREATETEMPORARY(lobd … lobd blob; fils BFILE:= BFILENAME('FILE_DIR','modem.jpg'); BEGIN DBMS_LOB.CREATETEMPORARY(lobd, TRUE

Reference, 10g Release 1 (10.1)

SI_StillImage Object Type

content, explicitFormat) constructor: DECLARE lobd BLOB; fils BFILE:= BFILENAME('FILE_DIR','window.psp'); newimage … : DECLARE lobd BLOB; fils BFILE:= BFILENAME('FILE_DIR','window.psp'); newimage SI_StillImage

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

3 Using Oracle XML DB

Comparing Partial to Full XML Schema ValidationINTO PURCHASEORDER VALUES ( XMLType ( bfilename('XMLDIR','InvalidElement.xml'), nls_charset_id … (object_value)=1); Table altered. -- INSERT INTO PURCHASEORDER VALUES ( XMLType ( bfilename('XMLDIR

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

4 XMLType Operations

Querying XML Data With SQL( xmltype ( bfilename('XMLDIR','SMCCAIN-2002091213000000PDT.xml'), nls_charset_id('AL32UTF8') ) ); 1 row … created. -- INSERT INTO PURCHASEORDER VALUES ( xmltype ( bfilename('XMLDIR','VJONES … . call insertPurchaseOrder(xmltype(bfilename('XMLDIR','purchaseOrder.xml'),nls_charset_id('AL32UTF8

SQL Reference, 10g Release 1 (10.1)

SQL Functions

Single-Row Functionsother single-row function categories: BFILENAME COALESCE CV DECODE DEPTH DUMP EMPTY_BLOB

Utilities, 10g Release 1 (10.1)

15 The ORACLE_DATAPUMP Access Driver

Unloading and Loading BFILE DatatypesRETURN NULL; 7 ELSE 8 RETURN BFILENAME(dir,file); 9 END IF; 10 END; 11 / Function created. The get_bfile

SQL Quick Reference, 10g Release 1 (10.1)

2 SQL Functions

Syntax for SQL FunctionsATAN2(n {, | / } m) AVG AVG([ DISTINCT | ALL ] expr) [ OVER(analytic_clause) ] BFILENAME BFILENAME

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

15 LOB APIs for BFILE Operations

15 LOB APIs for BFILE Operationsused in conjunction with the BFILENAME () function, in SQL and PL/SQL, or the OCILobFileSetName (), in … update it later to refer to an operating system file using the BFILENAME () function. OCI users can also … Lob_table ( Key_value NUMBER NOT NULL, F_lob BFILE) INSERT INTO Lob_table VALUES (21, BFILENAME('IMG … ', 'Image1.gif'));