Results for BFILENAME


21 to 40 of 54 results. Prev  Next
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'));





Was this page helpful?

Integrated Cloud Applications & Platform Services