/
/ $Header: template.txt 06-feb-96.13:23:24 kosinski Exp $
/
/ readmej.txt
/
/ Copyright (c) Oracle Corporation 2000. All Rights Reserved.
/
/   NAME
/     readmej.txt - <one-line expansion of the name>
/
/   DESCRIPTION
/     <short description of component this file declares/defines>
/
/   NOTES
/     <other useful comments, qualifications, etc.>
/
/   MODIFIED   (MM/DD/YY)
/   mpjoshi     05/19/00 - Creation
/

JAVA Large Object(LOBs) EXAMPLES  5/15/00
/rdbms/demo/lobs/jav examples

Note:
These lob examples are available in /rdbms/demo/lobs for the first time in 
Oracle8i release 3 (8.1.7). 
The example scripts, are taken from the "Oracle8i Application Developer's Guide - 
Large Objects (LOBs)" release 2 (8.1.6). The majority of these examples 
are based on the multimedia_tab schema. The set up and clean up scripts for 
these examples are described in the manual at the beginning of chapters 9,10,
and 11, and can also be found here in the file:
On UNIX:/rdbms/demo/adlsetup.sql
On NT: $HOME\demo\adlsetup.sql
For compilation and execution purposes, the filename and the class name
should match.

DOC REF		DEMO NAME	DESCRIPTION

Java (JDBC) Internal Persistant LOBs Examples from Chapter 9
* For the "DEMO NAME", the Internal Persistant LOBs examples have a prefix = i

adlj001i	iinstrow	inserting a row by initalizing lob bind variable
adlj002i	iinstval	inserting a value into lob using empty_clob()/empty_blob()
adlj003i	iloaddat	loading a lob with BFILE data
adlj004i	iifopen		seeing if lob is open
adlj005i	ichecko		checking out lob
adlj006i	ichecki		checking in lob
adlj007i	idisplay	displaying lob data
adlj008i	ireaddat	reading data from lob
adlj009i	ireadprt	reading portion of lob (substr)
adlj010i	icompare	comparing all or part of two lobs
adlj011i	ipattern	seeing if pattern exists in lob (instr)
adlj012i	ilength		getting length of lob
adlj013i	icopy		copying all or part of one lob to another
adlj014i	icopyloc	copying lob locator
adlj015i	iequal		seeing if one lob locator is equal to another
adlj016i	iappend		append one lob to another
adlj017i	iwriteap	writing to the end of lob (write append)
adlj018i	iwrite		writing data to a lob
adlj019i	itrim		trimming lob data
adlj020i	ierase		erasing part of lob
adlj021i	iupdate		updating by initializing lob locator bind variable	

Java (JDBC) Temporary LOBs Examples from Chapter 10
No java temporary lob examples are available for Oracle8i Release 2(8.1.6). 
See the forthcoming release.

Java (JDBC) External LOBs (Bfiles) Examples from Chapter 11
* For the "DEMO NAME", the External LOBs (bfile) examples have a prefix = f

adlj022f	finstrow	inserting a row using BFILENAME
adlj023f	finstloc		inserting a row containing bfile by initializing bfile locator
adlj024f	floadb		loading a lob with bfile data
adlj025f	fopen_fl	opening a bfile with FILEOPEN
adlj026f	fopen_op	opening a bfile with OPEN
adlj027f	fisopenf	seeing if bfile is open with FILEISOPEN
adlj028f	fisopeni	seeing if bfile is open with ISOPEN
adlj029f	fdisplay	displaying bfile data
adlj030f	freaddat	reading data from bfile
adlj031f	freadprt	reading portion of bfile data (substr)
adlj032f	fcompare	comparing all or parts of two bfiles
adlj033f	fpattern	seeing if pattern exists in bfile (instr)
adlj034f	fexists		seeing if bfile exists
adlj035f	flength		gettING length of bfile
adlj036f	fcopyloc	copying lob locator for bfile
adlj037f	fequal		seeing if one lob locator for a bfile is equal to another
adlj038f	fgetdir		gettING directory alias and file name	
adlj039f	fupdate		updating bfle by initializing bfile locator
adlj040f	fclose_f	closing bfile with FILECLOSE
adlj041f	fclose_c	closing bfile with CLOSE
adlj042f	fcloseal	closing all open bfiles

***********
