"Beginning Oracle PL/SQL" by Don Bales is an accessible guide for Oracle developers and DBAs to master PL/SQL. It focuses on essential features, emphasizing practical applications over theory. With examples and a clear approach, readers learn to write production-level, object-oriented PL/SQL and tackle real-world business challenges effectively.
JDBC is essential for accessing relational databases, and Oracle is a leading platform in this realm. This book by Donald Bales effectively combines these technologies, guiding you through leveraging Oracle's JDBC implementation. It begins with the crucial process of establishing database connections, a challenging area for newcomers. Donald provides detailed explanations and examples for making connections from applications, applets, Servlets, and even Java programs running within the database. The book thoroughly covers JDBC's relational SQL features, including issuing SQL statements and retrieving results. You'll learn to handle large, streaming data types like BLOBs, CLOBs, and BFILEs, and interface with PL/SQL, Oracle's built-in programming language. For those utilizing Oracle's newer capabilities to create object tables and user-defined data types, Don offers comprehensive insights. Additionally, you'll discover how to use JPublisher and JDBC to interact with Oracle database objects in Java programs, as well as access nested tables and arrays. The book concludes with essential discussions on transaction management, locking, concurrency, and performance—key topics for any professional JDBC programmer. If you develop Java applications for Oracle databases, this resource is indispensable.
The Java Database Connectivity (JDBC) specification is a complex set of application program interfaces (APIs) that developers need to understand if they want their Java applications to work with databases. This reference offers quick look-ups for all methods of the standard JDBC classes.