Results for BFILENAME


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





Was this page helpful?

Integrated Cloud Applications & Platform Services