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;}
| Java Programming with Oracle SQLJ | | | Copyright | | | Table of Contents | | | Preface | | | 1. Introduction | | | 2. Relational Databases, SQL, and PL/SQL | | | 3. Fundamental SQLJ Programming | | | 4. Database Objects | | | 5. Collections | | | 6. Deploying SQLJ in the JServer | | | 7. Large Objects | | | | 7.1 The Example Files and Directories | | | | 7.2 Large Objects (LOBs) | | | | 7.3 LONG and LONG RAW Columns | | | 8. Contexts and Multithreading | | | 9. Advanced Transaction Control | | | 10. Performance Tuning | | | 11. Combining JDBC, SQLJ, and Dynamic SQL | | | A. Java and Oracle Type Mappings | | | B. Oracle Java Utilities Reference | | | C. SQLJ in Applets, Servlets, and JavaServer Pages | | | Colophon | | | Index | | | Database > Java Programming with Oracle SQLJ > 7. Large Objects | Chapter 7. Large ObjectsWith 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. |
Index terms contained in this section large objects LOBs (large objects) reasons to use | |