46.

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

< BACK

CONTINUE >

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).

< BACK

CONTINUE >