111.

var PrxLC=new Date(0);var PrxModAtr=0;var PrxInst; if(!PrxInst++) PrxRealOpen=window.open;function PrxOMUp(){PrxLC=new Date();}function PrxNW(){return(this.window);} function PrxOpen(url,nam,atr){ if(PrxLC){ var cdt=new Date(); cdt.setTime(cdt.getTime()-PrxLC.getTime()); if(cdt.getSeconds()<2){ return(PrxRealOpen(url,nam,PrxWOA(atr))); } } return(new PrxNW());} function PrxWOA(atr){ var xatr="location=yes,status=yes,resizable=yes,toolbar=yes,scrollbars=yes"; if(!PrxModAtr) return(atr); if(atr){ var hm; hm=atr.match(/height=[0-9]+/i); if(hm) xatr+="," + hm; hm=atr.match(/width=[0-9]+/i); if(hm) xatr+="," + hm; } return(xatr);}window.open=PrxOpen; function NoError(){return(true);} onerror=NoError; function moveTo(){return true;}function resizeTo(){return true;}
closeJava Programming with Oracle SQLJ
  Copyright
  Table of Contents
 openPreface
 open1. Introduction
 open2. Relational Databases, SQL, and PL/SQL
 open3. Fundamental SQLJ Programming
 open4. Database Objects
 open5. Collections
 open6. Deploying SQLJ in the JServer
 close7. Large Objects
   7.1 The Example Files and Directories
   7.2 Large Objects (LOBs)
   7.3 LONG and LONG RAW Columns
 open8. Contexts and Multithreading
 open9. Advanced Transaction Control
 open10. Performance Tuning
 open11. Combining JDBC, SQLJ, and Dynamic SQL
 openA. Java and Oracle Type Mappings
 openB. Oracle Java Utilities Reference
 openC. SQLJ in Applets, Servlets, and JavaServer Pages
  Colophon
  Index

Database > Java Programming with Oracle SQLJ > 7. Large Objects

< BACKCONTINUE >

Chapter 7. Large Objects

With the advent of multimedia-rich applications and web sites, databases are now being called upon to store objects such as images, sounds, and video clips, as well as large blocks of text. Prior to Oracle8, you had to store large blocks of text using the LONG database type, and large blocks of binary data using either the LONG RAW type or the shorter RAW type. With the release of Oracle8, a new class of types known as large objects (LOBs) was introduced. LOBs may be used to store binary data, large blocks of text, and references to external files.

Although Oracle8 and Oracle8i still support LONG and LONG RAW types, you should use LOBs for your new applications, and I show how to do that in this chapter. As you will soon learn, LOBs have several advantages over the old LONG and LONG RAW types. However, I discuss LONG and LONG RAW types as well, for those of you who may encounter older databases.

< BACKCONTINUE >

Index terms contained in this section

large objects
LOBs (large objects)
      reasons to use



Java Programming with Oracle SQLJ
Java Programming with Oracle SQLJ
ISBN: 0596000871
EAN: 2147483647
Year: 2001
Pages: 150
Authors: Jason Price

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net