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


21 to 40 of 54 results. previous page Prev  Next next page
Results per page:   20  | 40


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'));