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 | | | | 2.1 Relational Databases | | | | 2.2 Structured Query Language (SQL) | | | | 2.3 PL/SQL | |  | 3. Fundamental SQLJ Programming | |  | 4. Database Objects | |  | 5. Collections | |  | 6. Deploying SQLJ in the JServer | |  | 7. Large Objects | |  | 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 > 2. Relational Databases, SQL, and PL/SQL | Chapter 2. Relational Databases, SQL, and PL/SQL As you now know, SQLJ enables you to access a database using SQL statements in your Java programs. Therefore, to use SQLJ, you need to know about databases and SQL. This chapter provides a basic introduction to relational databases, SQL, and Oracle's proprietary PL/SQL procedural language. It cannot possibly cover these large subjects in depth, but it will give you a strong enough foundation for you to be productive and to understand the rest of this book. For a detailed discussion of SQL, I recommend the book Oracle 8i: The Complete Reference by Kevin Loney and George Koch (Oracle Press). If you want to learn more about PL/SQL, I recommend Oracle PL/SQL Programming by Steven Feuerstein and Bill Pribyl (O'Reilly). | |