Preface. 1. Introduction Comparing SQL J and JDBC SQL J Components Requirements for Using SQL J Configuring Your Environment A "Hello World" Program for SQL J The sqlj Command-Line Utility Oracle JDeveloper. 2. Relational Databases, SQL, and PL/SQL Relational Databases Structured Query Language (SQL) PL/SQL. 3. Fundamental SQL J Programming SQL J Programs Database Connections Simple SQL J Statements Transactions Queries That Return Multiple Rows Nested Cursors PL/SQL in SQL J. 4. Database Objects ...
Read More
Preface. 1. Introduction Comparing SQL J and JDBC SQL J Components Requirements for Using SQL J Configuring Your Environment A "Hello World" Program for SQL J The sqlj Command-Line Utility Oracle JDeveloper. 2. Relational Databases, SQL, and PL/SQL Relational Databases Structured Query Language (SQL) PL/SQL. 3. Fundamental SQL J Programming SQL J Programs Database Connections Simple SQL J Statements Transactions Queries That Return Multiple Rows Nested Cursors PL/SQL in SQL J. 4. Database Objects Defining Object Types Object Columns and Object Tables Creating Custom Classes Accessing Database Objects Using SQL J Object Identifiers and REF Columns. 5. Collections VARRAYs Nested Tables Storing an Object Type in a Collection Collection Custom Classes Accessing Collections Using SQL J. 6. Deploying SQL J in the JServer Understanding the Oracle JServer Designing Server-Based SQL J Programs Translating SQLJ Programs Loading SQLJ Programs into the Database Publishing Class Methods Using Database Triggers Using JDeveloper to Translate and Load SQL J Programs Using Enterprise JavaBeans. 7. Large Objects The Example Files and Directories Large Objects (LOBs) LONG and LONG RAW Columns. 8. Contexts and Multithreading Connection Contexts Execution Contexts Multithreaded SQL J Programs. 9. Advanced Transaction Control Transaction Processing Problems Transaction Isolation Levels The SET TRANSACTION Statement A Transaction Isolation Level Example. 10. Performance Tuning Row Prefetching Batch Processing Tuning SQL Statements The Oracle Optimizer. 11. Combining JDBC, SQL J, and Dynamic SQL Static and Dynamic SQL Sharing Database Connections SQL J Iterators and JDBC Result Sets. A. Java and Oracle Type Mappings. B. Oracle Java Utilities Reference. C. SQL J in Applets, Servlets, and JavaServer Pages. Index
Read Less
Add this copy of Map Skills Ks1 to cart. $18.87, very good condition, Sold by Greener Books rated 4.0 out of 5 stars, ships from London, UNITED KINGDOM, published 1998 by Evans Brothers Ltd.
Choose your shipping method in Checkout. Costs may vary based on destination.
Seller's Description:
Very good. Ex-Library Copy **SHIPPED FROM UK** We believe you will be completely satisfied with our quick and reliable service. All orders are dispatched as swiftly as possible! Buy with confidence! Greener Books.
